search

Segs / Segs.dev

For segs.io config, scripts, themes, and issues
BSD 3-Clause "New" or "Revised" License
2 stars 0 forks source link

Increase MySQL wait_timeout value for SEGS on test servers #27

Closed ldilley closed 5 years ago

ldilley commented 5 years ago

In the [mysqld] section of my.cnf or my.ini on the pair of test servers, set the wait_time (and optionally the interactive_timeout) value to 604800 (7 days.) It is currently set to 28800 (8 hours.) This requires a restart of the database server and can be validated with the following query:

SELECT @@global.wait_timeout, @@session.wait_timeout;

This will be an OK workaround while we wait for a permanent fix for the "MySQL server has gone away" issue.

ldilley commented 5 years ago

Implemented and validated on both test servers (MySQL and SEGS services have also been restarted on both hosts):

SELECT @@global.wait_timeout, @@session.wait_timeout;
+-----------------------+------------------------+
| @@global.wait_timeout | @@session.wait_timeout |
+-----------------------+------------------------+
|                604800 |                 604800 |
+-----------------------+------------------------+
1 row in set (0.00 sec)