Closing unused pool connection

[miningpoolhub]

Hi
I've found that mysql pool connection is working well, but it really doesn't close connection even long time unused.
If there any API or trick to close unused connections in the pool?

I usually initialize pool by

mysql.createPool({
connectionLimit: someNumber
}

And I use

pool.query()

to query some data.

If there's no API for it, it would be good to have some flush() function to close idle connections.

[dougwilson]

Hi @miningpoolhub there is no API in the pool to close an idling connection, partly by design to keep the connection open as long as possible, since you should be sizing the pool for your load, you want the connections to stay open for when load returns. It also helps you spot when you have configured too many pools to open more connections than your server is willing to handle very quickly.

[miningpoolhub]

@dougwilson Thanks!

[sidorares]

there is pending #1749 that adds this (also #962 tracking this)