Toni Mueller wrote:
Hello Alexander,
On Tue, 29.08.2006 at 11:19:06 +0200, Alexander Hall <[EMAIL PROTECTED]> wrote:
mysqld_safe is a script that starts the mysql daemon and restarts it if
it crashes or so, so all is well.
well, it actually doesn't if the server just hangs. Here is what I get
when trying to talk to such a hung MySQL server:
ERROR 2013 (HY000): Lost connection to MySQL server during query
Well, that's true. Don't expect too much of it. Essentially it's just a
#/bin/sh
while ! /path/to/mysqld ${CONFIGURATION}; do
done
I haven't yet found a way to solve the problem - increasing resources
even to to much higher values than other people seem to require for
much busier sites than I serve, didn't help. I verified that the
settings actually take place by 'show variables' when the server runs
and also checked that login.conf matched. I was forced to create a
workaround that exernally checks mysqld and forces a restart in case
it's unresponsive.
As a side note, going from 5.0.21 to 5.0.22 worsened the problem
_significantly_ for me on two different servers running 3.9 using the
same configuration, and could not be mended by increasing these
resources.
Any ideas on how to debug this further are very welcome!
Well, I'm out of guesses. Sorry.
/Alexander
