Is it normal to see multiple processes for a single query?
MySQL is really overloaded on my server, so I look at SHOW PROCESSLIST for an idea of what is creating the load.
This often tells me that one unique query has up to ten processes running at once. Seems odd, and its very likely that my PHP code has gone haywire.
Anybody have any thoughts on this?
When I look at 'top' I see mysqld running 25 processes that are all the same size, and each time it refreshes the size grows. I have seen this go all the way up to 25 processes taking up 92M each apparently.
