Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

linux °²×° mysql rpm

ÔÚlinuxÏÂÃæ°²×°mysql£¬Ê×ÏàÒª¸ù¾Ý²Ù×÷ϵͳµÄ°æ±¾£¬Ñ¡Ôñ¶ÔÓ¦µÄmysqlµÄ°æ±¾£¬¹Ù·½ÍøÕ¾ÉÏÓзdz£Ã÷È·µÄ·ÖÀà
http://dev.mysql.com/downloads/
ÔÚÕâÀïÎÒʵÑéµÄ²Ù×÷ϵͳÊÇredhat linux
mysql ÓÃÁËÁ½¸ö°²×°°ü£¬Ò»¸öÊÇserver¶Ë£¬Ò»¸öÊÇclient,ÎÒÓõÄÊÇrpm°ü£¬°²×°µÄÖ¸Áî±È½Ï¼òµ¥¡£
MySQL-server-community-5.1.42-0.rhel4.i386
MySQL-client-community-5.1.42-0.rhel4.i386
ÍÆ¼ö²ÉÓõÄĬÈϵݲװ·¾¶£¬È»ºóÔËÐÐÁ½Ìõ¼òµ¥µÄÖ¸Áî¾Í°²×°Íê³ÉÁË¡£
rpm -Uhv MySQLMySQL-server-community-5.1.42-0.rhel4.i386
rpm  -Uhv MySQL-client-community-5.1.42-0.rhel4.i386
mysql°²×°µÄ¼¸¸öĬÈÏ·¾¶.
1,Êý¾ÝĿ¼£¬  /var/lib/mysql
2,ÅäÖÃÎļþ£¬ /usr/share/mysql
3,Ïà¹ØµÄÃüÁî /usr/bin
4,Æô¶¯½Å±¾ /etc/rc.d/init.d
°²×°Íê³É¹ýºóÈç¹û²»ÄÜÆô¶¯·þÎñ£¬
the server quit without updating PID file
Õâ¸ö´íÎóºÜ´ó²¿·ÖÊÇÓÉÅäÖÃÎļþÒýÆðµÄ£¬ÄãÖ»ÐèÒª¸ù¾ÝÄãϵͳµÄÅäÖðÑ/usr/share/mysqlÏÂÃæ¶ÔÓ¦µÄÅäÖÃÎļþcopyµ½/etc
²¢ÖØÃüÃûΪmy.cnf.Ñ¡ÔñºÏÊʵÄÅäÖÃÎļþ²Î¿¼http://www.kuqin.com/database/20090725/64156.html
ÅäÖÃÎļþ¸ã¶¨ºó£¬¾ÍÆô¶¯mysqlµÄ·þÎñ£¬
service mysql start  »òÕß/etc/rc.d/init.d/mysqld start Æô¶¯mysqlµÄ·þÎñ
È»ºó
shell> mysql 
¾ÍÄܽøÈëmysqlµÄ¿Í»§¶ËµÄ¹ÜÀí½çÃæÁË£¬Ëæ±ãÔËÐм¸ÌõmysqlµÄsqlÃüÁî¿´ÄãÊÇ·ñ³É¹¦¡£¡£


Ïà¹ØÎĵµ£º

²»¿É²»ÖªµÄ Linux Ê®ÏîÖØ´ó·¢Õ¹


Çì×£ Linux ³É¹¦ 10 Äê
Linux®¼¼Êõ¡¢¿ª·¢Ä£ÐͺÍÉçÇø¶¼¶Ô IT Òµ²úÉúÁËÖØÒªµÄÓ°Ï죬ÎÒÃÇÄÜ×öµÄ¾ÍÊÇÕ¾µ½Ò»±ß¿´¿´ÕâЩ£¬ºÜ¸ßÐËÓë
developerWorks Ò»Æð¶È¹ýÁ˵ÚÒ»¸ö 10 Äê¡£Linux ÍŶÓÒѾ­½«ÕâЩ¶Ô Linux ²úÉúÖØ´óÓ°ÏìµÄÄÚÈÝÕûÀíµ½Ò»Æð¡£
¹ýÈ¥ 10 ÄêÀLinux ·¢ÉúÁËÌ«¶àµÄÊÂÇ飬ºÜÄÑÍêÕûµØÁгö¸Ã²Ù×÷ϵͳµ ......

LinuxÄں˳£ÓÃÊý¾Ý½á¹¹ºÍ²Ù×÷

1. ǰÑÔ
 
±¾ÎĽéÉÜlinuxÄÚºËÖÐһЩ³£ÓõÄÊý¾Ý½á¹¹ºÍ²Ù×÷¡£
 
2. Ë«ÏòÁ´±í(list)
 
linuxÄÚºËÖеÄË«ÏòÁ´±íͨ¹ý½á¹¹ struct list_headÀ´½«¸÷¸ö½ÚµãÁ¬½ÓÆðÀ´£¬´Ë½á¹¹»á×÷ΪÁ´±íÔªËØ½á¹¹ÖеÄÒ»¸ö²ÎÊý£º
struct list_head {
 struct list_head *next, *prev;
};
 
Á´±íÍ·µÄ³õʼ»¯£¬×¢Ò⣬ ......

Ï̳߳¬Ê±µÈ´ý·½·¨ linuxÖÐselect()º¯ÊýʹÓÃ

selectϵͳµ÷ÓÃʱÓÃÀ´ÈÃÎÒÃǵijÌÐò¼àÊÓ¶à¸öÎļþ¾ä±úµÄ״̬±ä»¯µÄ¡£³ÌÐò»áÍ£ÔÚselectÕâÀïµÈ´ý£¬Ö±µ½±»¼àÊÓµÄÎļþ¾ä±úÓÐÒ»¸ö»ò¶à¸ö·¢ÉúÁË״̬¸Ä±ä¡£
¹ØÓÚÎļþ¾ä±ú£¬Æäʵ¾ÍÊÇÒ»¸öÕûÊý£¬Í¨¹ýsocketº¯ÊýµÄÉùÃ÷¾ÍÃ÷°×ÁË£º
int socket(int domain, int type, int protocol);
ÎÒÃÇ×îÊìϤµÄ¾ä±úÊÇ0¡¢1¡¢2Èý¸ö£¬0ÊDZê×¼ÊäÈ룬1ÊDZê ......

mysql 5.1 configure ±àÒë²ÎÊýÏê½â

-static  13%
   --with-client-ldflags=-all-static
  
--with-mysqld-ldflags=-all-static
¾²Ì¬Á´½ÓÌá¸ß13%ÐÔÄÜ
Unix Socket  7.5%
--with-unix-socket path=/usr/local/mysql/tmp/mysql.sock
ʹÓÃunixÌ×½Ó×ÖÁ´½ÓÌá¸ß7.5%ÐÔÄÜ£¬ËùÒÔÔÚwindowsÏÂmysqlÐÔÄܿ϶¨²»ÈçunixÏÂÃæ
--enab ......

Mysql »ù±¾µÄ³£ÓÃÃüÁî

ÓкܶàÅóÓÑËäÈ»°²×°ºÃÁË MySQL µ«È´²»ÖªÈçºÎʹÓÃËü¡£ÔÚÕâÆªÎÄÕÂÖÐÎÒÃǾʹÓÁ¬½Ó MySQL¡¢ÐÞ¸ÄÃÜÂë¡¢Ôö¼ÓÓû§µÈ·½ÃæÀ´Ñ§Ï°Ò»Ð© MySQL µÄ³£ÓÃÃüÁî¡£
Ò»¡¢Á¬½ÓMySQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
¡¡¡¡Ê×ÏÈÔÚ´ò¿ª DOS ´°¿Ú£¬È»ºó½øÈëĿ¼ mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ