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

¡¾×ª¡¿mysql½â¾ö×Ô¶¯¶Ï¿ª8Ð¡Ê±Î´ÔøÓùýµÄÁ´½Ó

http://www.cnblogs.com/neonlight/archive/2008/08/25/1276178.html
½üÒ»¶Îʱ¼ä£¬ºÜ¶à²¿ÃÅͬÊ·´Ó³ÔÚʹÓÃmysqlµÄ¹ý³Ì³öÏÖÊý¾Ý¿âÁ¬½Ó×Ô¶¯¶Ï¿ªµÄÎÊÌ⣬ÎÒ¶Ô¸ÃÎÊÌâ×öÁËһЩʵÑé¡£
¹ØÓÚmysql×Ô¶¯¶Ï¿ªµÄÎÊÌâÑо¿½á¹ûÈçÏ£¬ÔÚmysqlÖÐÓÐÏà¹Ø²ÎÊýÉ趨£¬µ±Êý¾Ý¿âÁ¬½Ó¿ÕÏÐÒ»¶¨Ê±¼äºó£¬·þÎñÆ÷¾Í
»á¶Ï¿ªµÈ´ý³¬Ê±µÄÁ¬½Ó£º
1¡¢Ïà¹Ø²ÎÊý£¬ºìÉ«²¿·Ö
mysql> show variables like '%timeout%';
+--------------------------+-------+
| Variable_name¡¡¡¡¡¡¡¡¡¡¡¡| Value  |
+--------------------------+-------+
| connect_timeout¡¡¡¡¡¡¡¡  | 5¡¡¡¡¡¡|
| delayed_insert_timeout¡¡ | 300¡¡ |
| innodb_lock_wait_timeout| 50¡¡¡¡ |
| interactive_timeout¡¡¡¡¡¡ | 28800 |
| net_read_timeout¡¡¡¡¡¡¡¡| 30¡¡¡¡ |
| net_write_timeout¡¡¡¡¡¡  | 60¡¡¡¡ |
| slave_net_timeout¡¡¡¡¡¡  | 3600¡¡|
| wait_timeout¡¡¡¡¡¡¡¡¡¡¡¡ | 28800 |
+--------------------------+-------+
ͬһʱ¼ä£¬ÕâÁ½¸ö²ÎÊýÖ»ÓÐÒ»¸öÆð×÷Óᣵ½µ×ÊÇÄĸö²ÎÊýÆð×÷Ó㬺ÍÓû§Á¬½Óʱָ¶¨µÄÁ¬½Ó²ÎÊýÏà¹Ø£¬È±Ê¡Çé¿öÏÂÊÇʹÓÃ
wait_timeout¡£ÎÒ½¨ÒéÊǽ«ÕâÁ½¸ö²ÎÊý¶¼Ð޸ģ¬ÒÔÃâÒýÆð²»±ØÒªµÄÂé·³¡£
2¡¢Ð޸IJÎÊý
ÕâÁ½¸ö²ÎÊýµÄĬÈÏÖµÊÇ8Сʱ¡£ÎÒ²âÊÔ¹ý½«ÕâÁ½¸ö²ÎÊý¸ÄΪ0£¬½á¹û³öÈËÒâÁÏ£¬ÏµÍ³×Ô¶¯½«Õâ¸öÖµÉèÖÃΪ1¡£»»¾ä»°Ëµ£¬²»Äܽ«¸ÃÖµÉèÖÃΪÓÀ¾Ã¡£ÎÒ½¨ÒéΪ²ÎÊýÖµ¼ÓÈý¸ö0£¬ÕâÑù¿Ï¶¨¿ÉÒÔÂú×ãÎÒÃǵÄÓ¦ÓÃÒªÇó¡£
Ð޸IJÙ×÷£º´ò¿ª/etc/my.cnf,ÔÚÊôÐÔ×émysqldÏÂÃæÌí¼Ó²ÎÊýÈçÏ£º
[mysqld]
interactive_timeout=28800000
wait_timeout=28800000
windowsÏÂÔÚmy.iniÎÄÖÐÔö¼Ó£º
interactive_timeout=28800000
wait_timeout=28800000


Ïà¹ØÎĵµ£º

MySql³£ÓÃÃüÁî

Ðè×¢ÒâÒÔÏÂÈýµã£º
1¡¢´´½¨Êý¾Ý¿âµÄʱºò£ºCREATE DATABASE `database`
                        CHARACTER SET 'utf8'
         ......

Safe Shutdown and Restart of MySQL Cluster


To shut down the cluster, enter the following command in a shell
on the machine hosting the management node:

shell> ndb_mgm -e shutdown
The -e
option here is used to pass a command to
the ndb_mgm
client from the shell. (See
Section 4.23, “ ......

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ÓÅ»¯µÄ8Ìõ¾­Ñé

1¡¢Ñ¡È¡×îÊÊÓõÄ×Ö¶ÎÊôÐÔ

MySQL
¿ÉÒԺܺõÄÖ§³Ö´óÊý¾ÝÁ¿µÄ´æÈ¡£¬µ«ÊÇÒ»°ã˵À´£¬Êý¾Ý¿âÖеıíԽС£¬ÔÚËüÉÏÃæÖ´ÐеIJéѯҲ¾Í»áÔ½¿ì¡£Òò´Ë£¬ÔÚ´´½¨±íµÄʱºò£¬ÎªÁË»ñµÃ¸üºÃµÄÐÔÄÜ£¬ÎÒÃÇ¿ÉÒÔ½«
±íÖÐ×ֶεĿí¶ÈÉèµÃ¾¡¿ÉÄÜС¡£ÀýÈ磬ÔÚ¶¨ÒåÓÊÕþ±àÂëÕâ¸ö×Ö¶Îʱ£¬Èç¹û½«ÆäÉèÖÃΪCHAR(255),ÏÔÈ»¸øÊý¾Ý¿âÔö¼ÓÁ˲»±ØÒªµÄ¿Õ¼ä£¬É ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ