Viewing the process list is a key step in debugging many common server problems, including bottlenecks, poor performance, deadlocks, connection issues, and many others. For that reason, knowing how to bring up relevant information on running processes is crucially important. In today’s article, we’re going to look at some ways to use the processlist to glean insight into potential server issues.
Mas:
http://www.databasejournal.com/features/mysql/handling-slow-processes-in-mysql.html
