Weblutions Documentation
Weblutions Main Site Contact Us Our Discord
Some pages are still pending proper formatting, if required refer to the legacy documentation website.
Knowledgebase IconKnowledgebase

Weblutions Documentation / Knowledgebase / Increase MySQL Idle Timeout

Updated

Increase MySQL Idle Timeout

By Josh M. 1 min 5

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!