Ò»Ö±ÒÔÀ´ÎÒµÄÎÄÕ¶¼ÊÇÒÔ¹¤×÷±Ê¼ÇµÄÐÎʽ´æÔÚ¡£Õâ¶ÔÓÚ×Ô¼º¶ÁÆðÀ´Ã»Ê²Ã´´ó°£¬µ«ÊǶÔÓÚÆäËû¶ÁÕß¿ÉÄܾÍÓÐЩÃÔã¡£ÎÒ¾¡Á¿¸Ä¸Ä£¬»»ÖÖ·½Ê½¡£
1. MySQL µÄ°æ±¾
Èç¹ûÒªÖ§³Ö·ÖÇø±í£¬ÔòÓ¦¸ÃʹÓà 5.1.x ÒÔÉϵİ汾¡£Èç
mysql> show variables like '%version%';
+-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| protocol_version | 10 |
| version | 5.1.45-community-log |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os &nbs ......
Ò»Ö±ÒÔÀ´ÎÒµÄÎÄÕ¶¼ÊÇÒÔ¹¤×÷±Ê¼ÇµÄÐÎʽ´æÔÚ¡£Õâ¶ÔÓÚ×Ô¼º¶ÁÆðÀ´Ã»Ê²Ã´´ó°£¬µ«ÊǶÔÓÚÆäËû¶ÁÕß¿ÉÄܾÍÓÐЩÃÔã¡£ÎÒ¾¡Á¿¸Ä¸Ä£¬»»ÖÖ·½Ê½¡£
1. MySQL µÄ°æ±¾
Èç¹ûÒªÖ§³Ö·ÖÇø±í£¬ÔòÓ¦¸ÃʹÓà 5.1.x ÒÔÉϵİ汾¡£Èç
mysql> show variables like '%version%';
+-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| protocol_version | 10 |
| version | 5.1.45-community-log |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os &nbs ......
Linux ²Ù×÷ϵͳ´ÓÒ»¿ªÊ¼¾Í¶Ô´®ÐпÚÌṩÁ˺ܺõÄÖ§³Ö,±¾ÎÄ¾Í Linux ϵĴ®ÐпÚͨѶ±à³Ì½øÐмòµ¥µÄ½éÉÜ¡£
´®¿Ú¼ò½é
´®ÐпÚÊǼÆËã»úÒ»ÖÖ³£ÓõĽӿÚ,¾ßÓÐÁ¬½ÓÏßÉÙ,ͨѶ¼òµ¥,µÃµ½¹ã·ºµÄʹÓᣳ£ÓõĴ®¿ÚÊÇ RS-232-C ½Ó¿Ú£¨ÓÖ³Æ EIA RS-232-C£©ËüÊÇÔÚ 1970 ÄêÓÉÃÀ¹úµç×Ó¹¤ÒµÐ»á£¨EIA£©ÁªºÏ±´¶ûϵͳ¡¢ µ÷ÖÆ½âµ÷Æ÷³§¼Ò¼°¼ÆËã»úÖÕ¶ËÉú²ú³§¼Ò¹²Í¬Öƶ¨µÄÓÃÓÚ´®ÐÐͨѶµÄ±ê×¼¡£ËüµÄÈ«ÃûÊÇ"Êý¾ÝÖÕ¶ËÉ豸£¨DTE£©ºÍÊý¾ÝͨѶÉ豸£¨DCE£©Ö®¼ä´®Ðжþ½øÖÆÊý¾Ý½»»» ½Ó¿Ú¼¼Êõ±ê×¼"¸Ã±ê×¼¹æ¶¨²ÉÓÃÒ»¸ö 25 ¸ö½ÅµÄ DB25 Á¬½ÓÆ÷,¶ÔÁ¬½ÓÆ÷µÄÿ¸öÒý½ÅµÄÐźÅÄÚÈݼÓÒԹ涨,»¹¶Ô¸÷ÖÖÐÅºÅµÄµçÆ½¼ÓÒԹ涨¡£´«Êä¾àÀëÔÚÂëÔª»û±äСÓÚ 4% µÄÇé¿öÏÂ,´«ÊäµçÀ³¤¶ÈӦΪ 50 Ó¢³ß¡£
Linux ²Ù×÷ϵͳ´ÓÒ»¿ªÊ¼¾Í¶Ô´®ÐпÚÌṩÁ˺ܺõÄÖ§³Ö,±¾ÎÄ¾Í Linux ϵĴ®ÐпÚͨѶ±à³Ì½øÐмòµ¥µÄ½éÉÜ,Èç¹ûÒª·Ç³£ÉîÈëÁ˽â,½¨Òé¿´¿´±¾ÎÄËù²Î¿¼µÄ¡¶Serial Programming Guide for POSIX Operating Systems¡·
¼ÆËã»ú´®¿ÚµÄÒý½Å˵Ã÷
¡¡ ¡¡
ÐòºÅ
ÐźÅÃû³Æ
·ûºÅ
Á÷Ïò
¹¦ÄÜ
2
·¢ËÍÊý¾Ý
TXD
DTE→DCE
DTE·¢ËÍ´®ÐÐÊý¾Ý
3
½ÓÊÕÊý¾Ý
RXD
DTE←DCE
DTE ½ÓÊÕ´®ÐÐÊý¾Ý
4
ÇëÇó·¢ËÍ
RTS
DTE→DCE
DTE ÇëÇ ......
µÚÒ»´ÎÔÚLinuxÉϰ²×°OracleµÄʱºòÅöµ½Õâ¸öÎÊÌ⣬ºÇºÇ¡£Ö®Ç°ÔÚLinuxÉϰ²×°Oracleʱ£¬Ò»°ã¶¼Ê¹ÓÃRedHatϵÁеÄLinux£¬ÔÚ°²×°¹ý³ÌÖУ¬ÐèÒª×ö´óÁ¿µÄ°²×°Ç°Öù¤×÷£¬Èç°²×°RPM°ü£¬´´½¨×éºÍÓû§£¬ÐÞ¸ÄÄں˲ÎÊý£¬Ð޸Ļ·¾³±äÁ¿µÈ¡£Õâ´ÎʹÓõÄÊÇRedFlagµÄAsianux 3£¬¶øÇÒ×Ô´øOracleµÄ°²×°¸¨Öú¹¤¾ßOranavi£¬Í¨¹ýͼÐλ¯½çÃæ°ïÖúÓû§½«ÕâЩǰÖù¤×÷¿ì½ÝÍê³É¡£
°´µÀÀí˵£¬Ê¹ÓÃÕâ¸ö°æ±¾µÄLinux£¬ºÜ¿ì¾ÍÄÜÍê³ÉOracleµÄ°²×°¹¤×÷ÁË£¬²¢ÇÒ֮ǰÏîÄ¿ÖÐÒѾÕâÑù°²×°¹ý£¬µ±Ê±Ã»ÓгöÏÖÈκÎÎÊÌ⡣ûÏëµ½Õâ´ÎµÄ°²×°È´Åöµ½ÁËһЩÎÊÌâ¡£ÏÈÊÇÔÚʹÓÃOranavi°²×°Ê±£¬ÌáʾOracleÓû§Ã»ÓÐȨÏÞÖ´ÐÐOracleµÄ°²×°³ÌÐò£¬ÓÚÊǰÑOracleµÄ°²×°³ÌÐòÎļþȨÏÞ±ä³ÉÈ«·Å¿ª£¬½á¹û»¹ÊÇͬÑùµÄ´íÎ󡣺óÀ´×ÉѯÁËÒ»ÏÂÖ§³Ö¹¤³Ìʦ£¬·¢ÏÖÎÊÌâ³öÔÚOracle°²×°³ÌÐòÎļþµÄĿ¼¡£ÎÒÔÚÉÏ´«Oracle°²×°Îļþʱ£¬½«Æä·ÅÔÚÁË/rootϵÄÒ»¸ö×ÓĿ¼£¬OracleÓû§ÔÚ¶ÁÈ¡Õâ¸öÎļþʱÊܵ½ÁËÏÞÖÆ¡£ÓÚÊǽ«Õâ¸öÎļþ·ÅÔÚÁËrootÖ®ÍâµÄĿ¼£¬²¢ÔÚOranaviÖÐÐÞ¸ÄÎļþĿ¼λÖã¬ÎÊÌâ±ã½â¾öÁË¡£
ÔÚ°²×°¿ìÒª½áÊø£¬´´½¨Êý¾Ý¿âʵÀýʱ£¬³öÏÖÁË“²ÎÊýPORTµÄÖµNULLÎÞЧ&rd ......
µÚÒ»´ÎÔÚLinuxÉϰ²×°OracleµÄʱºòÅöµ½Õâ¸öÎÊÌ⣬ºÇºÇ¡£Ö®Ç°ÔÚLinuxÉϰ²×°Oracleʱ£¬Ò»°ã¶¼Ê¹ÓÃRedHatϵÁеÄLinux£¬ÔÚ°²×°¹ý³ÌÖУ¬ÐèÒª×ö´óÁ¿µÄ°²×°Ç°Öù¤×÷£¬Èç°²×°RPM°ü£¬´´½¨×éºÍÓû§£¬ÐÞ¸ÄÄں˲ÎÊý£¬Ð޸Ļ·¾³±äÁ¿µÈ¡£Õâ´ÎʹÓõÄÊÇRedFlagµÄAsianux 3£¬¶øÇÒ×Ô´øOracleµÄ°²×°¸¨Öú¹¤¾ßOranavi£¬Í¨¹ýͼÐλ¯½çÃæ°ïÖúÓû§½«ÕâЩǰÖù¤×÷¿ì½ÝÍê³É¡£
°´µÀÀí˵£¬Ê¹ÓÃÕâ¸ö°æ±¾µÄLinux£¬ºÜ¿ì¾ÍÄÜÍê³ÉOracleµÄ°²×°¹¤×÷ÁË£¬²¢ÇÒ֮ǰÏîÄ¿ÖÐÒѾÕâÑù°²×°¹ý£¬µ±Ê±Ã»ÓгöÏÖÈκÎÎÊÌ⡣ûÏëµ½Õâ´ÎµÄ°²×°È´Åöµ½ÁËһЩÎÊÌâ¡£ÏÈÊÇÔÚʹÓÃOranavi°²×°Ê±£¬ÌáʾOracleÓû§Ã»ÓÐȨÏÞÖ´ÐÐOracleµÄ°²×°³ÌÐò£¬ÓÚÊǰÑOracleµÄ°²×°³ÌÐòÎļþȨÏÞ±ä³ÉÈ«·Å¿ª£¬½á¹û»¹ÊÇͬÑùµÄ´íÎ󡣺óÀ´×ÉѯÁËÒ»ÏÂÖ§³Ö¹¤³Ìʦ£¬·¢ÏÖÎÊÌâ³öÔÚOracle°²×°³ÌÐòÎļþµÄĿ¼¡£ÎÒÔÚÉÏ´«Oracle°²×°Îļþʱ£¬½«Æä·ÅÔÚÁË/rootϵÄÒ»¸ö×ÓĿ¼£¬OracleÓû§ÔÚ¶ÁÈ¡Õâ¸öÎļþʱÊܵ½ÁËÏÞÖÆ¡£ÓÚÊǽ«Õâ¸öÎļþ·ÅÔÚÁËrootÖ®ÍâµÄĿ¼£¬²¢ÔÚOranaviÖÐÐÞ¸ÄÎļþĿ¼λÖã¬ÎÊÌâ±ã½â¾öÁË¡£
ÔÚ°²×°¿ìÒª½áÊø£¬´´½¨Êý¾Ý¿âʵÀýʱ£¬³öÏÖÁË“²ÎÊýPORTµÄÖµNULLÎÞЧ&rd ......
understanding linux usb ehci device driver£¨2£©
understanding linux usb ehci device driver(2)
lm_tom@163.com
2. linux ehci device driver(ehci hcd)
2.1. linux usb subsystem arch overview(host)
2.2. ehci_hcd
2.3. ehci ʵÏֵĽӿÚ
2.3.1. ehci_pci_setup() (hc_driver->reset)
2.3.2. ehci_run() (hc_driver->start)
2.3.3. ehci_stop() (hc_driver->stop)
2.3.4. ehci_get_frame()(hc_driver-> get_frame_number)
2.3.5. ehci_urb_enqueue()(hc_driver->urb_enqueue)*
2.3.6. ehci_urb_dequeue()(hc_driver->urb_dequeue)
2.3.7. ehci_endpoint_disable()(hc_driver-> endpoint_disable)
2.3.8. ehci_irq()(hc_driver->irq)*
2.3.9. ehci_hub_control()(hc_driver->hub_control)
2.3.10. ehci_hub_status_data(hc_driver->hub_status_data)
1. linux ehci device driver(ehci hcd)
1.1.linux usb subsystem arch overview(host)
Fig 2-1 linux usb subsystem block diagram
Fig 2-1ÖÐ, ÂÌÉ«Ïß´ú±íµ÷ÓùØÏµ,ÂÌÏ߯ðµã(·Ç¼ýÍ·)Á¬½Ó·þ ......
Öܺ£ºº /ÎÄ
2010.4.22
¿´¼¯ÈºµÄ¶«Î÷ʱÎÞÒâÖп´µ½¼¸ÄêǰÁ÷Ðеķֲ¼Ê½¿ÆÑ§¼ÆËãseti@home£¬ÃÀ¹ú²®¿ËÀû´óѧµÈ¿ÆÑ§½çÓÃÓÚ¼ÆËãÌìÌåÊý¾ÝµÄ¡£SETI@home ÊÇÒ»ÏîÀûÓÃÈ«ÇòÁªÍøµÄ¼ÆËã»ú¹²Í¬ËÑѰµØÍâÎÄÃ÷£¨SETI£©µÄ¿ÆÑ§ÊµÑ鼯»®¡£Äã¿ÉÒÔͨ¹ýÔËÐÐÒ»¸öÃâ·Ñ³ÌÐòÏÂÔØ²¢·ÖÎö´ÓÉäµçÍûÔ¶¾µ´«À´µÄÊý¾ÝÀ´¼ÓÈëÕâ¸öÏîÄ¿¡£ ²»¹ýÎÒÔÙ´ÎʹÓÃÆä¿Í»§¶Ëʱ£¬¾ÓȻ˵ûÓмÆËãÈÎÎñ¡£¿´À´ÍâÌ«¿Õ̽Ë÷ÔÚÃÀ¹úÒ²²»ÊÜÖØÊÓÁË¡£
SETI@homeµÄ¿Í»§¶Ë BOINC Èí¼þ £¬linuxÏÂÊÇÒ»¸ösh½Å±¾¡£ÓÐÒâ˼µÄÊǸýű¾ÓÐ4M¶à¡£ÎÒÏëʲô½Å±¾Õâô´ó°¡£¿
ÏÂÏÂÀ´Ö´ÐÐһϣ¬¾ÓÈ»ÔÚĿ¼ÏÂÉú³ÉÒ»¶Ñ¶«Î÷¡£ÔÀ´¸Ã½Å±¾ÊǸö×Ô½âѹ½Å±¾¡£
·ÖÎöÁËһϣ¬×Ô¼º²¢·Â×öÁËÒ»¸ö¡£
½Å±¾Ç°ÈýÐУº
ÏȽ¨Ò»¸öĿ¼test£¬²¢ÈûÈëһЩҪ´ò°üµÄ¶«Î÷
zhouhh@zhh64:~/test$ ls
sendmail.py test.c testfor.sh
zhouhh@zhh64:~/test$ vi test.sh
ÊäÈ룺
#!/bin/sh
( read l; read l; read l ;exec cat ) < "$0" | gunzip | tar xf - && ls -l
exit
±£´æ£¬²¢¸ÄΪ¿ÉÖ´ÐÐÊôÐÔ¡£
¸Ã½Å±¾µÄÒâ˼£¬Èý¸öread l£¬ËæºóÒ»¸öcat,ÆäʵÊǶÁÈ¡test.shµÄǰÈýÐУ¬²¢¶ªÆú¡£¼´½«¸Ã½Å±¾µÄÈýÐв»×ö´¦Àí¡£´ÓµÚËÄÐпªÊ¼£¬Ë͸øgunzip£¬ÔÙË͸øtar½âѹ£¬×îºóÏ ......
±¾´Î°²×°µÄϵͳƽ̨Ϊredhat 5
Ò»¡¢Ê¹ÓÃRPM°ü½øÐа²×°
Ê×ÏÈ¿ÉÒÔ´Ó°²×°¹âÅÌÖлòÕßµ½mysqlµÄÍøÕ¾ÉÏÏÂÔØ¶ÔÓ¦°æ±¾µÄrpm°üÈçÏ£º
MySQL-server-community-5.1.38-0.rhel5.i386.rpm
MySQL-client-community-5.1.38-0.rhel5.i386.rpm
½Ó×ÅÎÒÃÇ¿ÉÒÔʹÓÃrpmÃüÁî½øÐа²×°£º
rpm -ivh MySQL-server-community-5.1.38-0.rhel5.i386.rpm
rpm -ivh MySQL-client-community-5.1.38-0.rhel5.i386.rpm
¶þ¡¢°²×°¶þ½øÖưü
²½ÖèÈçÏ£º
1¡¢ÓÃrootµÇ¼ϵͳ£¬Ôö¼ÓmysqlÓû§ºÍ×é
groupadd mysql
useradd -g mysql mysql
2¡¢½âѹ¶þ½øÖưü£¬¼ÙÈç¶þ½øÖưü·ÅÔÚ/home/mysqlÏ£¬ÎÒÃÇÔÚ½âѹºó²¢Ôö¼ÓÒ»¸ö·ûºÅÁ´½Ó
tar xvfz mysql-5.1.38-linux-i686-glibc23.tar.gz
ln -s mysql-5.1.38-linux-i686-glibc23 mysql
3¡¢ÔÚÊý¾Ý¿âĿ¼Ï´´½¨ÏµÍ³Êý¾Ý¿âµÄ±í£¬--user±íʾÕâЩÊý¾Ý¿âºÍ±íµÄËùÓÐÕßΪ´ËÓû§
cd mysql
./scripts/mysql_install_db --user=mysql
4¡¢ÉèÖÃĿ¼ȨÏÞ£¬½«dataĿ¼µÄËùÓÐÕ߸ÄΪmysql£¬ÆäËüĿ¼µÄÎļþµÄËùÓÐÕßΪroot
chown -R root:mysql .
chown -R mysql:mysql data
5¡¢Æô¶¯mysql
./bin/mysqld_safe --user=mysql ......
±¾´Î°²×°µÄϵͳƽ̨Ϊredhat 5
Ò»¡¢Ê¹ÓÃRPM°ü½øÐа²×°
Ê×ÏÈ¿ÉÒÔ´Ó°²×°¹âÅÌÖлòÕßµ½mysqlµÄÍøÕ¾ÉÏÏÂÔØ¶ÔÓ¦°æ±¾µÄrpm°üÈçÏ£º
MySQL-server-community-5.1.38-0.rhel5.i386.rpm
MySQL-client-community-5.1.38-0.rhel5.i386.rpm
½Ó×ÅÎÒÃÇ¿ÉÒÔʹÓÃrpmÃüÁî½øÐа²×°£º
rpm -ivh MySQL-server-community-5.1.38-0.rhel5.i386.rpm
rpm -ivh MySQL-client-community-5.1.38-0.rhel5.i386.rpm
¶þ¡¢°²×°¶þ½øÖưü
²½ÖèÈçÏ£º
1¡¢ÓÃrootµÇ¼ϵͳ£¬Ôö¼ÓmysqlÓû§ºÍ×é
groupadd mysql
useradd -g mysql mysql
2¡¢½âѹ¶þ½øÖưü£¬¼ÙÈç¶þ½øÖưü·ÅÔÚ/home/mysqlÏ£¬ÎÒÃÇÔÚ½âѹºó²¢Ôö¼ÓÒ»¸ö·ûºÅÁ´½Ó
tar xvfz mysql-5.1.38-linux-i686-glibc23.tar.gz
ln -s mysql-5.1.38-linux-i686-glibc23 mysql
3¡¢ÔÚÊý¾Ý¿âĿ¼Ï´´½¨ÏµÍ³Êý¾Ý¿âµÄ±í£¬--user±íʾÕâЩÊý¾Ý¿âºÍ±íµÄËùÓÐÕßΪ´ËÓû§
cd mysql
./scripts/mysql_install_db --user=mysql
4¡¢ÉèÖÃĿ¼ȨÏÞ£¬½«dataĿ¼µÄËùÓÐÕ߸ÄΪmysql£¬ÆäËüĿ¼µÄÎļþµÄËùÓÐÕßΪroot
chown -R root:mysql .
chown -R mysql:mysql data
5¡¢Æô¶¯mysql
./bin/mysqld_safe --user=mysql ......