mysql> show global 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 | | table_lock_wait_timeout | 50 | | wait_timeout | 900 | +--------------------------+-------+
¾È³çÇϼ¼¿ä. wait_timeout¿¡ ´ëÇؼ ±Ã±ÝÇÑ°Ô ÀÖ¾î¼ ±ÛÀ» ¿Ã·È½À´Ï´Ù. ¾îÇø®ÄÉÀ̼ǿ¡¼ Á¢¼Ó½Ã¿¡ Äõ¸® ¼öÇàÀ» ¸¶Ä¡°í sleep»óÅ·Π°è¼Ó ½Ã°£ÀÌ °¡Áö ¾Ê½À´Ï±î ( show processlist·Î È®ÀÎ ) ±×·±µ¥ wait_timeout = 30 À¸·Î ÇÏ¸é ´ç¿¬ 30ÃÊÈÄ¿¡ sleepµÈ »óÅ°¡ ²÷°Ü¾ß ÇÏ´Â °Ô ¾Æ´ÑÁö¿ä? ¼³Á¤À» 30À¸·Î Çسù´Âµ¥ °è¼Ó 31, 32, 33, 34 ... ÇÑ ¾øÀÌ ¿Ã¶ó°¡³×¿ä ²÷¾îÁ®¾ß Á¤»óÀÌ ¾Æ´Ñ°¡¿ä?
============================================= mysql> set session wait_timeout = 30; <-- ÀÌ·¸°Ô Çغ¸¼¼¿ä 30ÃÊÈÄ¿¡ ²÷¾îÁö´õ¶ó±¸¿ä ±×·±µ¥ my.cnf¿¡ wait_timeoutÀ» 30À¸·Î ³õ°í Çϸé Àúµµ ¼Ö·Î¾ÖÂù´Ôó·³ °è¼Ó 30ÃÊ°¡ ³Ñµµ·Ï Ä«¿îÆÃÀÌ µÇ¹ö¸®³×¿ä ¸¹Àº µµ¿òÀÌ µÇÁö ¸øÇؼ Á˼ÛÇÕ´Ï´Ù.
============================================= wait_timeoutÀº ¿¬°áÀ» ²÷±â Àü ¼¹ö¿¡¼ ´ë±âÇÏ´Â ½Ã°£À» ¸»ÇÕ´Ï´Ù. connect_timeoutÀº MySQL ¼¹ö ¿¬°á ½ÇÆÐ ¸Þ¼¼Áö¸¦ º¸³»´Â ½Ã°£À» ¸»ÇÕ´Ï´Ù. delayed_insert_timeoutÀº insert delayed Äõ¸®°¡ ³¡³ª±â Àü¿¡ insert Äõ¸®°¡ ±â´Ù¸®´Â ½Ã°£ ´Ù½Ã ¸»ÇØ Á¤ÇØÁø ½Ã°£ÀÌ ³Ñµµ·Ï insert¸¦ ÇÏÁö ¾ÊÀ¸¸é »èÁ¦µÇ´Â °ÍÀ» ÀǹÌÇÕ´Ï´Ù. interactive_timeoutÀº È°µ¿Çϴ Ŭ¶óÀ̾ðÆ®¸¦ ¼¹ö°¡ ±â´Ù·Á ÁÖ´Â ½Ã°£À» ¸»ÇÕ´Ï´Ù. net_read_timeoutÀº Àб⸦ ÁßÁöÇϱâ Àü¿¡ ´ÙÀ½ Àб⸦ ±â´Ù¸®´Â ½Ã°£À» ¸»ÇÕ´Ï´Ù. slave_net_timeout Àб⸦ ÁßÁöÇϱâ Àü¿¡ master/slave ¿¬°á¿¡¼ µ¥ÀÌÅ͸¦ ±â´Ù¸®´Â ½Ã°£À» ¸»ÇÕ´Ï´Ù.
============================================= ¼Ö·Î¾ÖÂù´ÔÀÌ »ý°¢ÇϽô wait_timeoutÀÌ interactive_timeoutÀÇ º¯¼ö¿Í °°ÀÌ ¼³Á¤À» ÇØÁÖ½Ã¸é ¿øÇϽô °á°ú¸¦ ¾òÀ» ¼ö ÀÖÀ» °Í °°³×¿ä.
¸Ó ´ë·« ÀоîºÁ¾ß ÇÑ´Ù´Â...
EOF : Zany (2009-08-03)
|
|
|
|
°Ô½ÃÆÇ ±Û ¸ñ·Ï |
|
No |
Subject |
Poster |
Hits |
Posted |
|
2154 |
|
helix |
4425 |
2009-09-09 23:25:53 |
|
2153 |
|
helix |
1566 |
2009-09-09 23:20:00 |
|
2152 |
|
helix |
2246 |
2009-09-09 23:16:05 |
|
2122 |
|
helix |
3236 |
2009-08-24 18:41:37 |
|
2091 |
|
helix |
1882 |
2009-08-10 14:04:43 |
|
|
|
helix |
2617 |
2009-08-03 20:40:05 |
|
2074 |
|
helix |
2440 |
2009-07-28 10:42:29 |
|
2065 |
|
helix |
9780 |
2009-07-22 19:07:51 |
|
2037 |
|
helix |
8141 |
2009-07-09 10:08:15 |
|
2018 |
|
helix |
1759 |
2009-06-17 17:25:10 |
|
1998 |
|
helix |
1658 |
2009-06-08 15:56:44 |
|
|
|
ÄÚ¸àÆ® |
|
|
|
|
|
|