½â¾ö 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
ÎÊÌâ½â¾ö
Ïà¹ØÎĵµ£º
±¾ÎÄÈí¼þµÄÏÂÔØµØÖ·¾Í²»Áгö£¬Ö÷ÒªÊǼǼ°²×°Ê±µÄ²½Öè¼°Ïà¹ØÎÊÌâµÄ´¦Àí·½·¨£»»ùÓÚ°²×°·½·¨Ä¿Ç°ÓÐÁ½ÖÖ£¬Ò»ÖÖÊÇÀûÓÃRPM°ü°²×°£¬Ò»ÖÖÔ´Âë±àÒë°²×°£»ÒÔÏÂÖ÷
ÒªÊÇÒÔÔ´Âë±àÒë°²×°£»ÒòΪԴÂë°²×°Èí¼þµÄÏ໥ÒÀÀµÐÔС£¬°²×°·½Ê½Óø÷ÖÖunix/linuxϵͳ£¬Î¬»¤·½±ã¡£Èç¹ûÏëÈ¥³ýÏà¹Ø·þÎñʱ£¬Ö±½Órm
–rfĿ¼ ¼´¿É£»½¨Òé²ÉÓÃÔ´Âë· ......
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Ö´ÐеÄʱ¼äÃ÷ ......
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ÖеĴ¥·¢Æ÷£¬¼ì²éÊý¾Ý±í´óС£¬Èç¹û³¬¹ýÔ¤É賤¶È£¬Ôòɾ³ý²¿·ÖÊý¾Ý¡£
CREATE TRIGGER ......
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 ......