How can I limit the number of child processes that MySQL spawns?
Fresh3 days ago
Mar 15, 20269111 viewsConfidence Score0%
0%
Problem
Is there a way to limit the number of children than spawns? Or should one not worry about that? My VPS only has 512MB of RAM. Here's the output of , after I set to 6 and restarted the service: I've installed MySQL using aptitude.
Error Output
PID USER PRI NI VIRT RES SHR S CPU% MEM% TIME+ Command 27082 mysql 20 0 136M 28868 5800 S 0.0 5.7 0:00.41 `- /usr/sbin/mysql…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How can I limit the number of child processes that MySQL spawns?
Low Risk
you could use max_user_connections to limit the number of connections that a single mysql user can have at one time http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_max_user_connections you'd need to try a few different set…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix