mySQL Timeout value

Follow

So you are running your own dedicated server - be it physical or virtual - and you have mySQL installed on your server. 

A common error that can occur with CMS or CRM applications - the information required for a particular function may take a while to query from the database - and you may sometimes receive an error message stating the SQL query failed due to the timeout being reached.

To quickly fix this follow these steps:

1) Log into the server via SSH

2) Type in and hit enter: vi /etc/my.cnf 

3) Locate the line: connect_timeout

4) Change the timeout value to a higher value (the value is in seconds): connect_timeout = 300

5) Restart the mySQL service (eg for CentOS): /etc/init.d/mysql restart

 

This will now resolve your timeout issue with mySQL queries.

Have more questions? Submit a request

Comments

Powered by Zendesk