#TIL : Sleeping connections in MySQL
Sleeping connections in MySQL
When you check your MySQL process list via command
show processlist;, it will show you a useful table which provide all current connection details.
“Sleep” state connections are most connection pointer waiting for the timeout to terminate. Then they still count as a connection. (Can cause MySQL connection limit error, which default equal 150 connections)
So next time, remember to close your connection before terminating your app.
Every connection counts ;)