ÈÃmemcachedºÍmysql¸üºÃµÄ¹¤×÷
¡¡Õâ´ÎÊÇFotolog
µÄ¾Ñ飬´«ËµÖбÈFlickr¸ü´óµÄÍøÕ¾
£¬FotologÔÚ21̨·þÎñ
Æ÷Éϲ¿ÊðÁË51¸ömemcachedʵÀý£¬×ܼÆÓÐ254G»º´æ¿Õ¼ä
¿ÉÓ㬻º´æÁ˶à´ï175GµÄÄÚÈÝ£¬Õâ¸öÊýÁ¿±ÈºÜ¶àÍøÕ¾µÄÊý¾Ý¿â¶¼Òª´óµÄ¶à£¬ÔÎÄÊÇA Bunch of Great Strategies for Using Memcached and MySQL Better Together
£¬ÎÒÕâÀﻹÊÇÑ¡ÔñÐԵķÒëÒÔ¼°°´ÕÕÎÒµÄÀí½â²¹³ä£¬¸ÐлTodd Hoff
£¬×ÜÄܸøÎÒÃÇ
һЩѧϰ
µÄ°¸Àý£¬´ÓÕâÀïÒ²ÄÜ¿´³ö¹úÍâ¼¼Êõ
µÄ¿ª·Å̬¶È£¬²»ËÆÎÒÃÇ£¬Æäʵ¾ÍÄÇôµãС¾Å¾Å»¹²Ø×ÅÒ´×Å£¬ºÃÁË£¬½øÈëÕýÌâ¡£
Ò»¡¢¹ØÓÚmemcached
¡¡¡¡»¹²»ÖªµÀÕâ¸ö£¿ÄÇÄãÈ¥ÃæÊÔµÄʱºòÒª³Ô¿÷ÁË£¬¸Ï½ôÈ¥¹Ù·½ÍøÕ¾¿´Ò»ÏÂhttp://www.danga.com/memcached/
£¬ÁíÍâgoogleÒ»ÏÂÓ÷¨£¬Ó²ÅÌ×ÜÊÇÌ«Âý£¬°ÑÊý¾Ý´æÔÚÄÚ´æÀïÃæ°É£¬Èç¹ûÄãÖ»ÓÐһ̨·þÎñÆ÷£¬ÍƼöÓÃÒ»ÏÂAPC
(FacebookÔÚÓÃ)»òÕßeaccelerator
»òÕßXcache
(¹úÈË¿ª·¢µÄ)£¬ÕâЩ²úÆ·µ¥»úЧ¹û¸üºÃ£¬Èç¹ûÄãÐèÒª
·Ö²¼Ê½µÄ»º´æ·½°¸£¬ÄÇôÓÃmemcached°É¡£
¶þ¡¢memcachedÈçºÎÓëmysql²¢¼ç×÷Õ½£¿
ͨ¹ýÊý¾Ý¿â·ÖƬÀ´½â¾öÊý¾Ý¿âдÀ©Õ¹µÄÎÊÌâ°ÑÊý¾Ý¿â·ÖƬ£¬²¿Êðµ½²»Í¬µÄ·þÎñÆ÷ÉÏ£¬ÃâµÃÖ»ÓÐÒ»¸öÖ÷·þÎñÆ÷£¬Ð´²Ù×÷³ÉΪƿ¾±ÒÔ¼°¿ÉÄÜÓеēµ¥µã¹ÊÕÏ”£¬Ò»°ãµÄÊý¾Ý¿â·ÖƬÖ÷ÒªÊÇ°´ÕÕÒµÎñÀ´·Ö£¬¾¡¿ÉÄܵIJð·ÖÒµÎñ£¬²»Ïà¸ÉµÄ¶¼¶ÀÁ¢ÆðÀ´
×ö³É·þÎñÒ²ºÃ
Ç°¶ËmysqlºÍÒ»¶Ñmemcached·þÎñÆ÷À´Ó¦¸¶¶ÁµÄÎÊÌâÓ¦ÓóÌÐòÊ×ÏÈ´ÓmemcachedÖлñÈ¡Êý¾Ý£¬»ñÈ¡²»µ½ÔÙ´ÓÊý¾Ý¿âÖлñµÃ²¢±£´æ
ÔÚmemcachedÖУ¬ÒÔÇ°¿´¹ýһƪÎÄÕÂ˵ºÃµÄÓ¦ÓÃ95£¥µÄÊý¾Ý´ÓmemcacheµÄÖлñµÃ£¬3£¥µÄÊý¾Ý´ÓmysqlµÄquery cacheÖлñµÃ£¬Ê£ÏÂ2£¥²ÅÈ¥²é±í£¬¶Ô±ÈÒ»ÏÂÄãµÄÓ¦Ó㬲î¾àÓжàÔ¶£¿
ͨ¹ýmysql¸´ÖÆ£¨master-slave£©À´½â¾ö¶ÁµÄÎÊÌâ
Ê×ÏÈmysqlÊý¾Ý¿âͨ¹ýmaster-slave¶Áд·ÖÀ룬¶à¸öslaveÀ´Ó¦¶ÔÓ¦ÓóÌÐò¶ÁµÄ²Ù×÷¡£
Èý¡¢ÎªÊ²Ã´²»ÓÃmysqlµÄquery cache£¿
¡¡¡¡ÎÒÃǶ¼ÖªµÀmysqlÓиöquery cache£¬¿ÉÒÔ»º´æÉϴβéѯµÄ½á¹û£¬¿Éʵ¼ÊÉÏ°ï²»ÉÏÌ«¶àµÄ棬ÏÂÃæÊÇmysql quety cacheµÄ²»×㣺
Ö»ÄÜÓÐÒ»¸öʵÀý
Òâζ×ÅÄãÄÜ´æ´¢ÄÚÈݵÄÉÏÏÞ¾ÍÊÇÄã·þÎñÆ÷µÄ¿ÉÓÃÄڴ棬һ̨·þÎñÆ÷ÄÜÓжàÉÙÄڴ棿ÄãÓÖÄÜ´æ¶àÉÙÄØ£¿
Ö»ÒªÓÐд²Ù×÷£¬mysqlµÄquery cache¾ÍʧЧ
Ö»ÒªÊý¾Ý¿âÄÚÈÝÉÔÓиıä
£¬ÄÇŸıäµÄÊÇÆäËûÐУ¬mysqlµÄquery cacheÒ²»áʧЧ
mysqlµÄquery cacheÖ»ÄÜ»º´æÊý¾Ý¿âÊý¾ÝÐÐ
Òâζ×ÅÆäËûÄÚÈݶ¼²»ÐУ¬±ÈÈçÊý×飬±ÈÈç¶ÔÏ󣬶ømemcachedÀíÂÛÉÏ¿ÉÒÔ»º´æÈκÎÄÚÈÝ£¬ÉõÖÁÎļþ^_^
ËÄ¡¢FotologµÄ»º´æ¼¼Êõ
·ÇÈ·¶¨ÐÔ»º´æ
Ïà¹ØÎĵµ£º
×òÌì½âÎöÁËdblp.xml£¬´æÈëÊý¾Ý¿â£¬Éú³ÉÁËÈô¸ÉÕÅÁÙʱ±í¡£½ñÌìÉÏÎ磬¶ÔÕâЩÁÙʱ±í½øÐд¦Àí£¬È»ºó´æÈëʵÑéÉè¼ÆµÄ±íÖС£Êý¾Ý¿âµÄÊý¾ÝÁ¿±È½Ï´ó£¬50¶àM£¬80¶àÍòÌõ¼Ç¼¡£Òò¶øÖ´ÐÐsqlʱ£¬¾ÍÓöµ½Á˺ܶàÎÊÌâ¡£
1¡¢È¥³ýÖظ´tuple
Ôʼdblp.xmlÖУ¬Í¬Ò»ÂÛÎĵĴæÔÚ¼¸¸öÍêÈ«ÏàͬµÄ&l ......
¿ÉÒԲ鿴mysqlÎļþĿ¼my.iniÎļþ£¬¿ÉÒÔÕÒµ½ÀàËÆÓÚ
datadir="D:/beeagle/Program Files/MySQL/MySQL Server 5.0/Data/"µÄ×Ö¶Î
¸Ã·¾¶Îªmysql dataĿ¼
ĬÈÏÔÚ£º"C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\Data\"
×¢Ò⣺Application DataÎļþ¼ÐÊÇÒþ²ØµÄ£¡£¡£¡
¿ÉÒÔÐÞ¸ÄÉÏÊöÅäÖ㬠......
ÒòΪMySQLÔÙdebianÏÂĬÈÏÊDz»ÔÊÐíÔ¶³ÌÁ¬½ÓµÄ£¬ËùÒÔÐèҪעÊ͵ôÕâ¸öÏÞÖÆ¡£ÎÒµÄMySQLÊÇÓÃapt-get°²×°µÄ£¬ËùÒÔ·¾¶ÊÇĬÈϵģ¨Èç¹ûÊÇ×Ô¼º
ÊÖ¶¯°²×°£¬¿ÉÒÔ×Ô¼ºÑ°ÕÒÏÂÕýÈ·µÄ·¾¶£©£¬ÓÃÃüÁî vi /etc/mysql/my.cnf ´ò¿ªÎļþ£¬×¢Ê͵ô bind-address = 127.0.0.1 ±£´æ:wq »Ø³µ¡£
È»ºóÔٵǼµ½MySQL·þÎñÆ÷¶Ë£¬ÔÚmysql¿âÏÂÖ ......
netbeans6.7ÖÐÏòmysql5ÖвåÈëÖÐÎÄÊý¾ÝʱÏÔʾ”data too long for column“µÄÎÊÌâ¡£
ÎÒµÄmysqlÖÐ×Ö·ûµÄÉèÖÃʱutf-8£¬²¢ÇÒÔÚ¿ØÖÆ̨ÖпÉÒÔ²åÈëÖÐÎÄÊý¾Ý²¢ÏÔʾ£¬µ«ÔÚnetbeansÖвåÈëÊý¾Ýʱȴ×ÜÊÇÏÔʾ”data too long for column“¡£»ù±¾¿ÉÒÔÅжÏÊÇÓÉÓÚnetbeansºÍmysqlÖ®¼äµÄÊý¾Ý½»»»³öÁ ......
´ËÎÄյݲװ·½·¨ÊÊÓÃÓÚWindows XPϵÄApache+PHP+MySQL°²×°¡£ 1. °²×°»·¾³
²Ù×÷ϵͳÊÇ Windows XP ÖÐÎÄ°æ, Apache, PHP, MySQL µÄ×îа汾ÊǽØÖ¹µ½ 2007.09.07£¬·Ö±ðÔÚÆä¹ÙÍøÏÂÔصÄ:
* Apache 2.2.6£ºhttp://apache.mirror.phpchina.com/httpd/binaries/win32/
* PHP 5.2.4 (Windows Binaries PHP 5.2.4 z ......