"MySQL server has gone away" error

[dstover]

On my OTRS 3.3.3 system, I am randomly experiencing "MySQL server has gone away" errors. I looked online and found information about the wait_timeout and interactive_timeout options, which are set by default to 28800 seconds. Theoretically I am thinking that maybe my MySQL is using up all its threads and then each thread is only timing out 8 hours later, leading to connection issues.

Am I on the right track with this? If not, please provide any insight that would be helpful. If so, please give me some input on the appropriate settings.

Thanks in advance for any assistance...Dan.

[wurzel]

Hi,

google helps. What about your Max_packet_size ?

Florian

[dstover]

My max_packet_size is set to 8M. Looks like maybe that should be made larger. I will try that and let you know if it works.

Thanks for the tip...Dan.