mysql status threads_mysql的show status 中 thread 的含义？

最新推荐文章于 2024-04-15 11:20:45 发布

杨不圆

最新推荐文章于 2024-04-15 11:20:45 发布

阅读量353

点赞数

文章标签： mysql status threads

本文链接：https://blog.csdn.net/weixin_32667433/article/details/113218305

版权

本文介绍了MySQL中几个关键的线程状态变量：Threads_cached（线程缓存数量）、Threads_connected（当前打开连接数）、Threads_created（为处理连接创建的线程数）以及Threads_running（当前未挂起的连接数）。通过这些指标可以评估MySQL服务器的运行状况并进行调优。

摘要由CSDN通过智能技术生成

你的理解错了

Threads_cached：

The number of threads in the thread cache. This variable was added in MySQL 3.23.17.

Threads_connected：

The number of currently open connections.当前打开的连接数

Threads_created：

The number of threads created to handle connections. If Threads_created is big, you may want to increase the thread_cache_size value. The cache miss rate can be calculated as Threads_created divided by Connections. This variable was added in MySQL 3.23.31.

Threads_running：

The number of threads that are not sleeping.当前未挂起的连接数