mysql服务器端的进程_MySQL服务器的进程状态笔记

mysql> show status like 'Threads%';

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

| Variable_name | Value |

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

| Threads_cached | 1 |

| Threads_connected | 50 |

| Threads_created | 105965 |

| Threads_running | 1 |

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

Threads_connected打开的连接数

Threads_created表示创建过的线程数

Threads_running是代表当前并发数

发现Threads_created值过大的话，表明MySQL服务器一直在创建线程，这也是比较耗资源，可以适当增加配置文件中thread_cache_size值

mysql> show variables like 'thread_cache_size';

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

| Variable_name | Value |

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

| thread_cache_size | 9 |

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

mysql> set global thread_cache_size=32

或vim /etc/my.cnf

[mysqld]

thread_concurrency = 32