Again another quick post more for my notes than anything, had a few issues with the ESET ERA 6 Appliance losing connections from the clients, basically the clients connection time goes over the policy you have set.
A restart of the appliance gets it up and running for so long but then it will happen again, advice from ESET is to deploy a new appliance but i decided to try a few things first.
What worked for me –
Enter the console
Edit MySQL configuration (/etc/my.cnf) –
vi /etc/my.cnf
Then add the following to the [mysqld] section
innodb_lock_wait_timeout=600
The timeout value can be adjusted all the way up to 3600.