Lampwrights Forum

Lampwrights Forum (http://www.lampwrights.com/index.php)
-   MySQL (http://www.lampwrights.com/forumdisplay.php?f=3)
-   -   Finding MySQL Bottlenecks (http://www.lampwrights.com/showthread.php?t=4)

Jeff 07-18-2010 09:33 PM

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.


All times are GMT -4. The time now is 08:41 PM.

Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2020, vBulletin Solutions, Inc.