Limit MySQL forked processes

Question

How can you limit the amount of processes that MySQL forks? I noticed at startup there are at least 10 children. This is a development database that isn't in production; so no users are connecting to it.

Solution

You can try to reduce the number of processes/threads, by changing following values:

max_user_connections

max_connections

max_delayed_threads

For example in my.cnf:

max_connections = 1
max_user_connections = 1
max_delayed_threads = 1

But this does not guarantee that there will be less processes/threads, as not all processes/threads are connection related.

Comments

[b13n1u]

Unfotunately, there is no simple solution to limit the processes.