如何设置MySQL进程或线程的最大数量? [英] How can I set the max number of MySQL processes or threads?
问题描述
ps axuw| grep mysql
仅表示MySQL进程,但是如果我运行htop,我可以看到10行,每行都有一个单独的PID.所以我想知道它们是线程还是进程,由于某种原因我看不到使用ps.
ps axuw| grep mysql
indicates only MySQL process, but if I run htop I can see 10 rows each one of them with a separate PID. So I wonder if they are threads or processes that for some reason I cannot see using ps.
在我的开发机器上尝试将它们限制为两个是没有任何意义的,因为我不需要很多客户端的并发访问.
Would it make any sense to try to limit them to two on my development machine, where I don't need concurrent access of many clients.
在Ubuntu 8.10上运行的BTW
BTW Running on Ubuntu 8.10
推荐答案
您可以这样设置my.ini中的最大线程数:
You can set the max number of threads in your my.ini like this:
max_connections=2
不过,您可能还需要设置以下内容:
However you might also want to set this:
thread_cache_size=1
即使没有任何反应,线程缓存也可以控制打开多少缓存.
The thread cache controls how many it keeps open even when nothing is happening.
这篇关于如何设置MySQL进程或线程的最大数量?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!