Re: MySQL hangs server completely

2013-05-22 Thread Michael Ross
On Wed, 22 May 2013 15:52:45 +0200, Alejandro Imass wrote: Hi, We've been having this problem with a customer for a while and it seems that some funky query makes MySQL use 100% of CPU. Nevertheless, even though you can see in top that it's only 1 CPU in 100% (out of 8) the server eventually

Re: MySQL hangs server completely

2013-05-22 Thread Alejandro Imass
On Wed, May 22, 2013 at 2:04 PM, Michael Ross wrote: > On Wed, 22 May 2013 15:52:45 +0200, Alejandro Imass > wrote: > >> Hi, >> >> We've been having this problem with a customer for a while and it >> seems that some funky query makes MySQL use 100% of CPU. Nevertheless, >> even though you can see

MySQL hangs server completely

2013-05-22 Thread Alejandro Imass
Hi, We've been having this problem with a customer for a while and it seems that some funky query makes MySQL use 100% of CPU. Nevertheless, even though you can see in top that it's only 1 CPU in 100% (out of 8) the server eventually becomes useless and stops responding completely. So my question