Lampwrights Forum

Lampwrights Forum (
-   MySQL (
-   -   Finding MySQL Bottlenecks (

Jeff 07-18-2010 08: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:

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 06:19 PM.

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