MySQL and SSH framework, the reason the project will expire the next day.

The above error, I carefully read the code, check the online information, the first time that the database link pool configuration errors, and then the link pool configured, the next day, the problem. The second time is the colleague said the package conflict, but I decisively ruled out. Because the referenced rack package is not referenced. The third time, the discovery is the MySQL database problem. Because the database default link time is broken after 8 hours.

Use the code:

"Under the Black form"

Show global variables like ' wait_timeout '//query MySQL connection time

+--------------------------+-------+
| variable_name | Value |
+--------------------------+-------+
| Connect_timeout | 5 |
| Delayed_insert_timeout | 300 |
| Innodb_lock_wait_timeout | 50 |
| Interactive_timeout | 28800 |
| Net_read_timeout | 30 |
| Net_write_timeout | 60 |
| Slave_net_timeout | 3600 |
| Wait_timeout | 28800 |
+--------------------------+-------+

At the same time, only one of these two parameters works. Which parameter is in effect, related to the connection parameter specified when the user connects, by default, Wait_timeout is used. I recommend that you modify both parameters to avoid causing unnecessary trouble.

The default value for these two parameters is 8 hours (60*60*8=28800). I tested to change these two parameters to 0, the result is unexpectedly, the system automatically set this value to 8 hours. In other words, the value cannot be set to permanent.
Set these 2 parameters to 24 hours (60*60*24=604800);

Modification Method:
Set interactive_timeout=604800;
Set wait_timeout=604800;
The above is the content for reference only!

MySQL and SSH framework, the reason the project will expire the next day.