Relating a MySQL Process to Server Process

All of this assumes LAMP (specifically CentOS 6, MySQL server 5.5, Apache 2+ with mod-status enabled) On mysql server: watch -n 1 “mysql -e ‘show processlist’;” Look for sleeping connections that are staying open for a while. Watch for a trend. When you see a connection that you think will stay open for long enough, […]