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

Re: MySQL hangs server completely

2013-05-22 Thread Alejandro Imass
On Wed, May 22, 2013 at 2:04 PM, Michael Ross g...@ross.cx wrote: On Wed, 22 May 2013 15:52:45 +0200, Alejandro Imass aim...@yabarana.com 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

Re: MySQL hangs server completely

2013-05-22 Thread Michael Ross
On Wed, 22 May 2013 15:52:45 +0200, Alejandro Imass aim...@yabarana.com 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)