I now maintain a popular internet sports portal which runs mySQL.
Last weekend, the server (x86 linux) started grinding to a halt. When
I list the processes, there are many, many (much more than the number of
webserver threads!) mysqld threads running at once, sitting on the CPU
for long
universe wrote:
Hi David,
I've seen a similar behavior on our machine. We had someone re-write the
code for a particular PHP site that was producing tons of slow queries
(while the CPU was 100% idle the script would still take 15 seconds to
run its queries) and the problem was (sort of) fixed.
