mysqlÊý¾ÝÒÆÖ²
1. ÔÚÆäËü»úÆ÷ÉÏÊ×ÏȰ²×°ºÃÐèÒªµÄmysql ºÍ¶ÔÓ¦µÄ¹ÜÀíÈí¼þ£¨ÉèÖõÄÃÜÂëºÍÔ´Êý¾Ý¿âÃÜÂëÒ»Ö£©
2. ½«Ô´»úÆ÷ÉÏdataϵÄÊý¾Ý¿âÎļþ¼Ð£¨ÒÔÎҵĻúÆ÷ΪÀý£¬¾ÍÊÇrubberFactoryÎļþ¼Ð£¬ÆäÖУ¬
Õâ¸öÎļþ¼ÐϵÄÊý¾ÝÎļþ¶¼ÊÇһЩ±í½á¹¹¶¨Ò壩¿½±´µ½Ä¿±ê»úÆ÷dataÏ¡£
3. Í£Ö¹mysql·þÎñ£¬½«ibdata1Õâ¸öÎļþ¿½±´µ½dataÎļþ¼ÐÏ£¬¸²¸ÇÔÀ´µÄibdata1Îļþ¡£
4. ÖØÐÂÆô¶¯mysql·þÎñ£¬²¢Ë¢Ð£¬´ËʱÔٲ鿴Êý¾Ý¿âÖеÄÊý¾Ý£¬¼´OK¡£
Ïà¹ØÎĵµ£º
bigint ´Ó -2^63 (-9223372036854775808) µ½ 2^63-1 (9223372036854775807) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 8 ¸ö×Ö½Ú¡£
int ´Ó -2^31 (-2,147,483,648) µ½ 2^31 - 1 (2,147,483,647) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 4 ¸ö×Ö½Ú¡£int µÄ SQL-92 ͬÒå×ÖΪ integer¡£
smallint ´Ó -2^15 (-32,768) µ½ 2^15 - 1 (32,7 ......
Êý¾Ý¿âµÄÒ»ÕűíÀïÃæ´æÁ˹ØÓÚһ̨É豸µÄ±¸·ÝÅäÖÃÐÅÏ¢£¬ÀàÐÍÊÇbit£¬Ö÷Òª¾ÍÊÇÊÇ·ñÒѾÅäÖã¬ÉèÖõÄʱºòȡֵÊÇtrue,false,»¹ÊÇ0£¬1ÄØ£¿
¾À½áÁ˰ëÌ죬¶¯Ê־ͺÃÁË£¬ÊÇ0£¬1£¬¶ø·Çtrue,false£¬
¸üÐÂÓï¾äÈçÏÂ
update table_a
set configBaked= 0
where id in (2,3,4)
......
֮ǰ£¬Ò»Ö±À§ÄպܾõÄMySQLµÄÎÊÌâÒòΪÓÐÁËtcmallocºóµÃÒÔ½â¾ö¡£
ÎÊÌâÊÇ£ºÍøÕ¾·ÃÎÊÁ¿²»¸ß£¬¸ß·åʱ²¢·¢ÊýÔÚ300-400Ö®¼ä¡£CPU±È½Ï¸ß£¬ÔÚ30-80%Ö®¼ä²¨¶¯µÃÀ÷º¦£¬Ê¹ÓÃtopÃüÁî¿ÉÒÔ¿´µ½ÊÇmysql½ø³Ìµ¼Ö£¬Í¬Ê±ÓÃiostatºÍsar²é¿´iowaitÖµºÜ¸ßÔÚ20-30Ö®¼ä¡£
µ«ÊÇϵͳ»¹¿ÉÒÔÎȶ¨ÔËÐУ¬È»ºóÖÜÆÚÐԵijöÏÖswap·ÖÇøÕ¼ÓÃÂÊÅÊÉý£¬Ö±½Óµ¼Ö ......
http://blog.chinaunix.net/u/14014/showart_490462.html
mysql>show variables like '%timeout';
´òÓ¡½á¹ûÈçÏ£º
+----------------------------+-------+
| Variable_name | Value |
+----------------------------+-------+
| connect_timeout | 5 |
| delayed_insert_timeout | 300 |
| interactive_ ......
ÔÚaccessÖбíÖÐÊý¾Ýµ¼³öΪÎı¾Îļþµ½MySQLµÄÎÊÌ⣿
µ¼³öÎı¾Îļþʱºò£¬¿ÉÒÔÑ¡Ôñ×ֶηָô·û£¬À´°ÑÿһÁиô¿ª ºÍ Îı¾Ê¶±ð·û£¬À´°ÑcharÐÍÊý¾ÝÀ¨ÆðÀ´
ÎÒÏÖÔÚÓÓ£¬”×÷Ϊ×ֶηָô·û£¬²»Ê¹ÓÃÎı¾Ê¶±ð·û
Éú³ÉµÄÎı¾ÎļþÈçÏÂ
1£¬ÕÅÈý£¬ÄУ¬£¬Öйú ÉϺ££¬80501206
2£¬ÍõÎ壬Ů£¬Öйú ±±¾© ......