mysql 数据库当前连接数_mysql 数据库查看当前连接数

mysql查看当前连接数：

mysql> show status like "%Threads_%";

+-------------------+-------+

| Variable_name | Value |

+-------------------+-------+

| Threads_cached | 6 |

| Threads_connected | 45 |

| Threads_created | 12925 |

| Threads_running | 1 |

+-------------------+-------+

4 rows in set (0.05 sec)

mysql>

设置thread_cache_size大小

mysql> set global thread_cache_size=64

-> ;

Query OK, 0 rows affected (0.04 sec)

show full processlist;查看mysql当前连接详情

查看thread_cache_size大小

mysql> show variables like '%thread_cache_size%';

+-------------------+-------+

| Variable_name | Value |

+-------------------+-------+

| thread_cache_size | 10 |

+-------------------+-------+

1 row in set (0.06 sec)

查看max_connections，Max_used_connections 数据

mysql> show variables like '%max_connections%';

+-----------------+-------+

| Variable_name | Value |

+-----------------+-------+

| max_connections | 151 |

+-----------------+-------+

1 row in set (0.09 sec)

mysql> show global status like 'Max_used_connections';

+----------------------+-------+

| Variable_name | Value |

+----------------------+-------+

| Max_used_connections | 152 |

+----------------------+-------+

1 row in set (0.06 sec)