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

½â¾ö ubuntu ÉϵÄmysqlÎÞ·¨Ô¶³Ì·ÃÎÊ

ÔÚUbuntu9.10ÉÏʹÓÃsudo apt-get install mysql-server-5.0 °²×°ÁËmysql£¬ÔÚÍâÃæ·ÃÎʲ»ÁËmysql,µ«ÊÇÔÚUbuntuÉÏ·ÃÎÊÊÇûÓÐÎÊÌâµÄ¡£
ÓÚÊÇ¿ªÊ¼²éÕÒÔ­Òò£º
3306¶Ë¿ÚÊDz»ÊÇûÓдò¿ª£¿
ʹÓÃnestatÃüÁî²é¿´3306¶Ë¿Ú״̬£º
~# netstat -an | grep 3306
tcp        0      0
127.0.0.1:3306          0.0.0.0:*               LISTEN
´Ó½á¹û¿ÉÒÔ¿´³ö3306¶Ë¿ÚÖ»ÊÇÔÚIP 127.0.0.1ÉϼàÌý£¬ËùÒԾܾøÁËÆäËûIPµÄ·ÃÎÊ¡£
½â¾ö·½·¨
£ºÐÞ¸Ä/etc/mysql/my.cnfÎļþ¡£
´ò¿ª
Îļþ£¬ÕÒµ½ÏÂÃæÄÚÈÝ£º
# Instead of skip-networking the default is now to listen only on
#
localhost which is more compatible and is not less secure.
bind-address  =
127.0.0.1
°ÑÉÏÃæÕâÒ»ÐÐ×¢Ê͵ô»òÕß°Ñ127.0.0.1»»³ÉºÏÊʵÄIP£¬½¨Òé×¢Ê͵ô¡£
ÖØÐÂÆô¶¯ºó£¬ÖØÐÂʹÓÃnetstat¼ì²â£º
~# netstat -an | grep 3306
tcp       
0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN
ÎÊÌâ½â¾ö


Ïà¹ØÎĵµ£º

CentOS+Apache+Mysql+Php°²×°¼°ÓÅ»¯ÅäÖÃС¼Ç


±¾ÎÄÈí¼þµÄÏÂÔØµØÖ·¾Í²»Áгö£¬Ö÷ÒªÊǼǼ°²×°Ê±µÄ²½Öè¼°Ïà¹ØÎÊÌâµÄ´¦Àí·½·¨£»»ùÓÚ°²×°·½·¨Ä¿Ç°ÓÐÁ½ÖÖ£¬Ò»ÖÖÊÇÀûÓÃRPM°ü°²×°£¬Ò»ÖÖÔ´Âë±àÒë°²×°£»ÒÔÏÂÖ÷
ÒªÊÇÒÔÔ´Âë±àÒë°²×°£»ÒòΪԴÂë°²×°Èí¼þµÄÏ໥ÒÀÀµÐÔС£¬°²×°·½Ê½Óø÷ÖÖunix/linuxϵͳ£¬Î¬»¤·½±ã¡£Èç¹ûÏëÈ¥³ýÏà¹Ø·þÎñʱ£¬Ö±½Órm
–rfĿ¼ ¼´¿É£»½¨Òé²ÉÓÃÔ´Âë· ......

MySQLÏÂlimitºÍjoinµÄÓÅ»¯½¨Òé

PHPÖзÖÒ³¿Ï¶¨»áʹÓõ½MySQLµÄlimit,´ó²¿·Ö¶ÔÀàËÆ"select * from title where uid =** order by id desc limit m,n"ºÜÊìϤ,Ò²²»ÊÇÈ«²¿¶¼ÄÜ¿´³öÀïÃæÓÐʲô²»¶Ô,¿ÉÊǵ±ÊÇÔÚ´óÊý¾ÝÁ¿Ï²Ù×÷ÄØ,±ÈÈç°ÙÍòÀàËÆ"select * from title where uid =177 order by id desc limit 1234567,20"¾Í»á·¢ÏÖsqlÖ´ÐеÄʱ¼äÃ÷ ......

Fedora 8ÏÂÓÃYum°²×°Apache+PHP+MySQL»·¾³


fedora8 ÓÃyumÀ´¹ÜÀí°²×°Apache+PHP+MysqlµÄ»ù±¾°²×°¡£
1. °²×°Apahce, PHP, Mysql, ÒÔ¼°phpÁ¬½Ómysql¿â×é¼þ¡£
yum -y install httpd php mysql mysql-server php-mysql
2. ÅäÖÿª»úÆô¶¯·þÎñ
/sbin/chkconfig httpd on             [ÉèÖÃapache·þÎñÆ÷httpd·þÎñ¿ª»úÆô¶¯]
......

MySQL´¥·¢Æ÷½â¾ö·½°¸Àú³Ì

×î½ü£¬ÏîÄ¿ÖÐÓõ½mysql£¬ÓÉÓÚÊý¾ÝÁ¿·Ç³£´ó£¬Ã¿ÌìµÄÊý¾ÝÁ¿ÔÚ°ÙÍò¼¶£¬¿¼Âǵ½mysqlÊý¾Ý¿â´¦ÀíÐÔÄÜÒÔ¼°Êý¾ÝÊôÐÔ£¬¾ö¶¨±£´æ×ã¹»¶àµÄ²éѯÊý¾Ý¼´¿É£¬¾àµ±Ç°Ê±¼ä×î¾ÃÔ¶µÄÊý¾ÝÖ±½Óɾ³ý£¬ÎÞÐè½øÐб¸·Ý¡£
Í·ÄÔÖÐð³öµÄµÚÒ»¸öÏë·¨¾ÍÊÇ£¬ÄÜ·ñÀûÓÃmysqlÖеĴ¥·¢Æ÷£¬¼ì²éÊý¾Ý±í´óС£¬Èç¹û³¬¹ýÔ¤É賤¶È£¬Ôòɾ³ý²¿·ÖÊý¾Ý¡£
CREATE TRIGGER ......

MySQL Query Cache

A Practical Look at the MySQL Query Cache
http://dev.mysql.com/tech-resources/articles/mysql-query-cache.html
Êý¾Ý¿â»º´æ²ßÂÔ£º
£¨1£©»º´æ¾­³£±»Ê¹ÓõÄÊý¾Ý
£¨2£©»º´æ¾­³£Ö´ÐеÄSQLºÍ´æ´¢¹ý³Ì´úÂë
£¨3£©»º´æÊý¾Ý¿âÔªÊý¾ÝÐÅÏ¢£¬°üÀ¨£º¶ÔÏó½á¹¹»º´æ¡¢°²È«ÐÅÏ¢µÈ
mysqlÒýÇæËùʹÓõĻº´æ£º
£¨1£©myisam:key b ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ