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

[Mike Handley]

Hi,

> > 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

I was having timeout problems too and set these to 24 hours. It didn't entirely
solve my problem although it did help a great deal. 

What I discovered in the end was to decrease the number of child servers in
/etc/amavisd.conf. I presume what was happening was it was only using a subset
of the processes and the one's that weren't being used were the ones that were
causing the timeout.

--
Mike