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 ;)
Enjoyed this?
Leave a kudo — it means a lot.
0