MySQL »óÅ ȮÀÎ
MySQL »óÅ ȮÀÎ
MySQL¸¦ »ç¿ëÇÏ´Ùº¸¸é ¼¹ö»óŸ¦ È®ÀÎÇØ¾ßµÉ ¶§°¡ ÀÖ½À´Ï´Ù.
MySQL ¼³Á¤Á¤º¸, Ä¿³Ø¼Ç µîµî È®ÀÎÇÒ¶§ ²À ÇÊ¿äÇÑ ¸í·É¾î¸¦ ¾Ë¾Æº¸°Ú½À´Ï´Ù.
| MySQL »óÅ ȮÀÎ |
[MySQL ÇöÁ¦ »óÅ ȮÀÎ]
1 | mysql> show status; |
[MySQL ¼³Á¤È¯°æº¯¼ö¿Í °ª È®ÀÎ]
1 | mysql> show variables; |
[MySQL ÃÖ´ë µ¿½Ã Á¢¼Ó °¡´É ¼ö È®ÀÎ]
1 2 3 4 5 6 7 | mysql> show variables like '%max_connection%' ; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 100 | +-----------------+-------+ 1 row in set (0.00 sec) |
MySQL ¼¹ö´Â µ¿½Ã¿¡ ¿¬°áµÉ ¼ö Àִ Ŭ¶óÀ̾ðÆ®ÀÇ ¼ö°¡ ±âº»À¸·Î 100¸íÀ¸·Î ¼³Á¤µÇ¾î ÀÖ½À´Ï´Ù. µ¿½Ã Á¢¼ÓÀÚ¼ö¸¦ º¯°æÇÏ·Á¸é mysql.cnf(MySQL)ÆÄÀÏÀ» ¼öÁ¤ÇÏ°í MySQLÀ» Àç½ÃÀÛ ÇϸéµË´Ï´Ù
[MySQL °Á¦ÀûÀ¸·Î Á¾·áµÇ¾úÀ» ¶§ÀÇ »óÅ°ª È®ÀÎ]
1 2 3 4 5 6 7 | mysql> show status like 'Aborted_clients' ; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | Aborted_clients | 2 | +-----------------+-------+ 1 row in set (0.00 sec) |
¿¬°á °úÁ¤Áß¿¡¼ ½ÇÆеǴ °æ¿ìÀÇ °ªÀÔ´Ï´Ù.
Aborted_client : Ŭ¶óÀ̾ðÆ®°¡ Á¤»óÀûÀ¸·Î ¿¬°áµÇ¾úÁö¸¸ ÀÌÈÄ ºÎÀûÀýÇÏ°Ô È¤Àº °Á¦ÀûÀ¸·Î Á¾·áµÇ¾úÀ»¶§ÀÇ »óÅ°ªÀÔ´Ï´Ù.(Ŭ¶óÀ̾ðÆ®°¡ ¼¹ö¿¡ Á¢¼ÓÇÒ ¼ö ¾øÀ» °æ¿ì¿¡µµ Áõ°¡ÇϰԵ˴ϴÙ)
Aborte_client ¿øÀÎ
* Ŭ¶óÀ̾îÆ®°¡ µ¥ÀÌÅͺ£À̽º¿¡ Á¢±ÙÇÒ ±ÇÇÑÀÌ ¾ø´Â °æ¿ì
* Á¢¼Ó½Ã ºñ¹Ð¹øÈ£¸¦ Ʋ·ÈÀ»°æ¿ì
* Connection PacketÀ» ¾òÀ» ¶§ connect_timeout ½Ã°£º¸´Ù ¿À·¡ °É¸± °æ¿ì
[MySQL ¿¬°áÀÌ °Á¦·Î Ãë¼ÒµÈ °æ¿ìÀÇ »óÅ°ª È®ÀÎ]
1 2 3 4 5 6 7 | mysql> show status like 'Aborted_connects' ; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | Aborted_connects | 3 | +------------------+-------+ 1 row in set (0.00 sec) |
mysqld¿Í mysql client°¡ TCP ¿¬°áÀ» ¸Î´Â ÃÖ´ë ½Ã°£À¸·ÎÀÌ ½Ã°£º¸´Ù Å«°æ¿ìÀÇ °ªÀÔ´Ï´Ù.
[MySQL Ä¿³Ø¼Ç È®ÀÎ]
1 2 3 4 5 6 7 | mysql> show status like 'Connections' ; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Connections | 6058 | +---------------+-------+ 1 row in set (0.00 sec)
|