| Oracle/MySQL 관련 게시판 |
|---|
| 2008/06/17(16:43) from 211.109.178.9 | |
| 작성자 : 강줄기 (jkkang65@hanmail.net) | 조회수 : 3432 , 줄수 : 48 |
| [MySQL] DB 상태 확인하기 |
|---|
|
mysql> show variables like '%max_connection%' +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 100 | +-----------------+-------+ 1 row in set (0.01 sec) mysql> show status like '%connect%'; +----------------------+-------+ | Variable_name | Value | +----------------------+-------+ | Aborted_connects | 0 | | Connections | 107 | | Max_used_connections | 12 | | Threads_connected | 4 | +----------------------+-------+ 4 rows in set (0.00 sec) mysql> show status like '%client%'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | Aborted_clients | 0 | +-----------------+-------+ 1 row in set (0.00 sec) mysql> show status like '%thread%'; +------------------------+-------+ | Variable_name | Value | +------------------------+-------+ | Delayed_insert_threads | 0 | | Slow_launch_threads | 0 | | Threads_cached | 6 | | Threads_created | 13 | | Threads_connected | 3 | | Threads_running | 2 | +------------------------+-------+ 6 rows in set (0.00 sec) |
|
|