Debugging sleeping connections

by JellicleCat   Last Updated June 29, 2020 19:06 PM

I'm troubleshooting an app that has a lot of sleeping connections to my MySQL (MariaDB) server. I'd like to see just what the queries are on these sleeping connections, but when I run SHOW FULL PROCESSLIST, the Info column holds only NULL.

I suspect theses connections represent long-running queries, but it's a sizeable app, and I'm not sure what parts are creating the offending queries.

Is there a way for me to discover what the queries are?



Related Questions



how to execute mysql query after 1 minute

Updated August 27, 2018 23:06 PM

MySQL import failed with process in 'sleep' state

Updated July 07, 2017 14:06 PM


How to restart MariaDB Galera cluster?

Updated October 11, 2016 09:02 AM