| 1 | = MySQL = |
| 2 | |
| 3 | * 查詢同時連線數上限 |
| 4 | {{{ |
| 5 | mysql> SHOW VARIABLES where Variable_name like 'max_connect%'; |
| 6 | +--------------------+-------+ |
| 7 | | Variable_name | Value | |
| 8 | +--------------------+-------+ |
| 9 | | max_connect_errors | 100 | |
| 10 | | max_connections | 151 | |
| 11 | +--------------------+-------+ |
| 12 | 2 rows in set (0.00 sec) |
| 13 | }}} |
| 14 | * 查詢目前的同時連線數 |
| 15 | {{{ |
| 16 | |
| 17 | mysql> show status where `variable_name` = 'Threads_connected'; |
| 18 | +-------------------+-------+ |
| 19 | | Variable_name | Value | |
| 20 | +-------------------+-------+ |
| 21 | | Threads_connected | 151 | |
| 22 | +-------------------+-------+ |
| 23 | 1 row in set (0.00 sec) |
| 24 | }}} |
| 25 | * 查詢目前連線的 process |
| 26 | {{{ |
| 27 | mysql> show processlist; |
| 28 | +----+-------+-----------+-------+---------+------+-------+------------------+ |
| 29 | | Id | User | Host | db | Command | Time | State | Info | |
| 30 | +----+-------+-----------+-------+---------+------+-------+------------------+ |
| 31 | | 1 | root | localhost | NULL | Query | 0 | init | show processlist | |
| 32 | | 5 | cacti | localhost | cacti | Sleep | 292 | | NULL | |
| 33 | | 6 | cacti | localhost | cacti | Sleep | 311 | | NULL | |
| 34 | | 7 | cacti | localhost | cacti | Sleep | 7 | | NULL | |
| 35 | | 8 | cacti | localhost | cacti | Sleep | 7 | | NULL | |
| 36 | | 10 | cacti | localhost | cacti | Sleep | 306 | | NULL | |
| 37 | | 11 | cacti | localhost | cacti | Sleep | 306 | | NULL | |
| 38 | | 12 | cacti | localhost | cacti | Sleep | 306 | | NULL | |
| 39 | | 33 | cacti | localhost | cacti | Sleep | 0 | | NULL | |
| 40 | | 34 | cacti | localhost | cacti | Sleep | 1 | | NULL | |
| 41 | | 35 | cacti | localhost | cacti | Sleep | 37 | | NULL | |
| 42 | | 36 | cacti | localhost | cacti | Sleep | 4 | | NULL | |
| 43 | | 37 | cacti | localhost | cacti | Sleep | 7 | | NULL | |
| 44 | | 38 | cacti | localhost | cacti | Sleep | 7 | | NULL | |
| 45 | | 39 | cacti | localhost | cacti | Sleep | 7 | | NULL | |
| 46 | | 40 | cacti | localhost | cacti | Sleep | 7 | | NULL | |
| 47 | | 41 | cacti | localhost | cacti | Sleep | 7 | | NULL | |
| 48 | +----+-------+-----------+-------+---------+------+-------+------------------+ |
| 49 | 17 rows in set (0.00 sec) |
| 50 | }}} |