search

snower / TorMySQL

The highest performance asynchronous MySQL driver by PyMySQL
MIT License
308 stars 63 forks source link

I want know if set idle_seconds=0 and wait_connection_timeout=7200 will not be a problem？ #19

Closed uhayate closed 7 years ago

uhayate commented 7 years ago

In my project， I set

idle_seconds=0,
wait_connection_timeout=7200

This will cause the system to go wrong？

snower commented 7 years ago

No, no problem, idle_seconds is 0 pool will not recycle connection, then the connection is free than mysql server settings after the timeout will not be disconnected, the next use will appear "MySQL server has gone" error, wait_connection_timeout said from the pool Get the maximum waiting time before the connection to prevent the high concurrent request is to accumulate the request to cause the avalanche.