[Maia-users] web pages hang on maia, forced to reboot server. ..

[Robert LeBlanc]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Kurt Buff wrote:

>> [mysqlhotcopy]
>> interactive-timeout
> 
> Sorry to reply to myself. Blindness on my part. The entry
> interactive-timeout doesn't have a parameter in any of the my-*.cnf example
> files, nor in mine. The question remains, then, will it hurt to increase
> innodb_lock_wait_timeout?

First, try commenting out the "interactive-timeout" line to let MySQL
use its default value for that setting.  Also check the command-line
arguments you're using to start MySQL, since some of those may override
the settings in your my.cnf file.

If all else fails, consider adding a couple of timeout values explicitly
to the [mysqld] section of your my.cnf file:

 interactive_timeout = 86400
 wait_timeout = 86400

The default for both of these values is 28800 seconds (8 hours), but
increasing this to 86400 (24 hours) might give you more insurance
against slow periods.  Remember to restart mysqld after changes to your
my.cnf file.

As for innodb_lock_wait_timeout, that's not likely to be the problem in
this case.  That's a setting that's more likely to come into play when
the server is /busy/, whereas I suspect your disconnections are
occurring when the server is /idle/.

- --
Robert LeBlanc <rjl at renaissoft.com>
Renaissoft, Inc.
Maia Mailguard <http://www.maiamailguard.com/>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)

iD8DBQFGsZRtGmqOER2NHewRAsyTAKCs+Xtlgv6ibbvc/FCAzezgOljdNwCfdowW
TCdcGE3DdXiSw1AOIFceD+E=
=zsfw
-----END PGP SIGNATURE-----