Finding MySQL Bottlenecks

Jeff · 07-18-2010, 08:33 PM

Sometimes MySQL just slows down and it is hard to find where the issue is. One of the best ways I have found to start investigating is to watch the processes during the affected times. If you are logged into your MySQL terminal it is simple:

Code:

show processlist;

This will show you each connection, and the state of it and the status of the query. A lot of times during trouble you may see a connection sleeping for a long time, or a locked table, or other such things that help begin to solve the mystery.

Navicat has a server monitor GUI that helps you visualize the process list and can watch multiple servers at once.

07-18-2010, 08:33 PM	#1
Jeff Administrator Join Date: Jul 2010 Posts: 402 Rep Power: 10	Finding MySQL Bottlenecks Sometimes MySQL just slows down and it is hard to find where the issue is. One of the best ways I have found to start investigating is to watch the processes during the affected times. If you are logged into your MySQL terminal it is simple: Code: show processlist; This will show you each connection, and the state of it and the status of the query. A lot of times during trouble you may see a connection sleeping for a long time, or a locked table, or other such things that help begin to solve the mystery. Navicat has a server monitor GUI that helps you visualize the process list and can watch multiple servers at once.
	Reply With Quote

troubleshooting mysql