View Single Post
07-18-2010, 08:33 PM   #1
Jeff's Avatar
Join Date: Jul 2010
Posts: 402
Rep Power: 10
Jeff is getting browny points
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:
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.
Jeff is offline   Reply With Quote