Knowledgebase

Discord OAuth Redirects
Find Process By Port
How to Access Ubuntu Server
Increase MySQL Idle Timeout
LEMN Stack Install
NGINX Upload Limits [413 Entity Too Large]
Transfer Files Between Servers
TypeError: Setting User Fix
Using Node Version Manager
Running Node Version On One Instance
Using Screen Sessions

Weblutions Documentation > Knowledgebase > Increase MySQL Idle Timeout

Increase MySQL Idle Timeout

Have you ever experienced an read ECONNRESET error in FaxStore or another product? Well, there is a way to fix this.

By default MySQL uses an idle timeout which forces a connection to close if a query hasn't been ran in the set amount of time. Generally by default this is 8 hours. So here's how to increase this limit.

1. Navigate to /etc/mysql/mysql.conf.d
2. Open the file named mysqld.cnf and find the wait_timeout setting, add it if needed.
3. Increase this limit to a higher amount, the value is in seconds.

Example; 3153600 is 36 days.

wait_timeout = 3153600

Hope this guide helps and don't hesitate to reach out via our Discord if you need!

Suggest an edit

Review this page

• Login