mysql 线程数,如何设置MySQL进程或线程的最大数量？

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.

BTW Running on Ubuntu 8.10

解决方案

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.