Memcache VS MySQL Query Cache.
¼ÇµÃǰÌìÓÐÈËÎÊÎÒ£¬ Memcache ºÍ MySQL ×Ô¼ºµÄ Query Cache ÓÐÉ¶Çø±ð? ÎÒÕâÑù»Ø´ðµÄ£¬Ç°ÕßÊÇɽկÖеÄÕ½¶·»ú£¬ºóÕßÊǹٷ½µÄÕ½¶·»ú¡£
ÐÂÊֻشðÎÊÌ⣬´íÁËι֡£¹þ¹þ¹þ¡£
ºÃÏñϸ½ÚÉϵIJî±ð»¹ÊÇÓеġ£
MemcacheÓŵãÈçÏ£º
1. ÀíÂÛÉÏ¿ÉÒÔÖ§³ÅÎÞÏÞ²¢·¢ÒµÎñ²Ù×÷¡£
2. ¿ÉÒÔÆôÓõ¥¶ÀµÄʵÀýÀ´»º´æ¾Þ¶àµÄÊý¾Ý¡££¨µ±È»ÄãµÄ»úÆ÷ÄÚ´æ×ã¹»´ó£¬¶øÇÒ±ðÊÇ32-bitµÄÁË¡££©
3. ¿ÉÒÔÔڷdz£Á®¼ÛµÄ»úÆ÷ÉÏÔËÐС£
µ±È»Ò²ÓÐȱµã£º
1. ÔÝʱûÓйٷ½·þÎñÖ§³Ö¡£
2. Ì«ÈÝÒײúÉúÄÚ´æË鯬ÁË£¬ÀË·ÑÄÚ´æ¡£
3. ÐèÒªÐÞ¸ÄÓ¦ÓóÌÐò¡£
Query Cacahe ÓŵãÈçÏ£º
1. Óйٷ½µÄ¼¼ÊõÖ§³Ö¡££¨Õâ¸öµ¥µ¥Ö»¹ºÂòÁËÆóÒµ°æµÄÓû§£©
2. ¶ÔÓ¦ÓóÌÐò͸Ã÷¡£ ÎÒÃǵĿª·¢ÈËÔ±ÀÖÁË¡£
ȱµãÄØÒ²ÓУº
1. ²»ÄÜ·Ö¿ª×Ô¼ºµÄÕâ¿éBUFFERµ½µ¥¶ÀµÄ»úÆ÷¡££¨²»ÖªµÀÄܲ»ÄܹرÕMySQL µÄÖ÷Òª¹¦ÄÜ£¬¶øµ¥¶À°ÑQuery Cache´ò¿ªÄØ? ÓÐÐËȤµÄ¿ÉÒÔÊÔÑéÏ¡££©
2. Ò²ºÜÈÝÒײúÉúÄÚ´æË鯬£¬Í¬ÑùÀË·ÑÄÚ´æ¡£
ÆäʵÉÏÃæËµµÄÓеãǣǿ£¬Èç¹ûÄãµÄÓ¦ÓóÌÐòÍêÈ«OO£¬ÄÇô¶ÔÓÚMemcacheÀ´½²£¬Ö»ÐèÒª×öÉÙÁ¿µÄÐ޸ļ´¿É¡£
Ïà¹ØÎĵµ£º
create procedure all_joiner_message( in captions varchar(255), in contents text, in objectid int, in types int , out count int)
begin
declare userids int;
DECLARE _done IN ......
ÒÔÏÂÄÚÈÝÔÚubuntu 9.04 serverϵͳÉϲâÊÔͨ¹ý
ÓÃapt-get install vsftp°²×°µÄʱºòÏà¹ØµÄÎļþλÖãº
Ö÷ÅäÖÃÎļþ£º/etc/vsftpd.conf
ÑéÖ¤ÅäÖÃÎļþ/etc/pam.d/vsftpd
ÖØÆô£º/etc/init.d/vsftpd restart
vsftp MysqlÑéÖ¤·½Ê½£º
MYSQLÒѾ°²×°ÔÚ/usr/local/mysql
Ö±½Ó°²×°vsftp
sudo apt-get install vsftp
°²×°pam_mys ......
Ðè×¢ÒâÒÔÏÂÈýµã£º
1¡¢´´½¨Êý¾Ý¿âµÄʱºò£ºCREATE DATABASE `database`
CHARACTER SET 'utf8'
  ......
Starting the cluster is not very difficult after it has been configured. Each cluster node process must be started separately, and on the host where it resides. The management node should be started first, followed by the data nodes, and then finally by any SQL nodes:
On the management host, issu ......
ÒÔÏÂת×Ô Osss.cn Óʼþ£¬ÇëʹÓùý¡¢ÕýÔÚʹÓûòÕßÖ§³Ö¿ªÔ´µÄÅóÓÑÖ§³ÖÒ»ÏÂMySql£¬Ð»Ð»¡£
ҲϣÍû½ÌÓý²¿¡¢¿Æ¼¼²¿¸øÓèÖ±½ÓÖ§³Ö£¡
´ó¼ÒºÃ£º½ñÌì¿´µ½ÕâÔòÐÂÎÅ£¬Óë´ó¼Ò¹²Ïíһϣ¬MySQL´´Ê¼ÈËÏ£ÍûÖйúÉÌÎñ²¿ÄܽéÈëOracle&SunÊÕ¹º°¸£¬ºÃÏñ²¢Ã»ÓÐʵÖʽøÕ¹¡£¶ø¶íÂÞ˹Áª°î·´Â¢¶Ï»ú¹¹ÔÚÉÏÖÜÕ¹¿ªµ÷²é¡£Èç¹ûÐèÒªÉÌÎñ² ......