Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 22 May 2013 09:52:45 -0400
From:      Alejandro Imass <aimass@yabarana.com>
To:        FreeBSD Questions <freebsd-questions@freebsd.org>
Subject:   MySQL hangs server completely
Message-ID:  <CAHieY7R6Xz=p-6RHN0rKyJaOLBufRv4tNR_XTW3T3Q=bShFGow@mail.gmail.com>

Next in thread | Raw E-Mail | Index | Archive | Help
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 is, how does a user process hang the whole server? What
system resources could MySQL be draining to make the server stop
responding completely?

The MySQL database is running inside a Jail and perhaps that could
help limit the damage it can cause. Has anyone else run into this
problem?

Thanks,

-- 
Alejandro Imass



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?CAHieY7R6Xz=p-6RHN0rKyJaOLBufRv4tNR_XTW3T3Q=bShFGow>