Lampwrights Forum > Linux, Apache, MySQL, PHP > MySQL
Register Community Today's Posts Search

Reply
 
Thread Tools
07-18-2010, 08:33 PM   #1
Jeff
Administrator
 
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:
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.
Jeff is offline   Reply With Quote

Reply

Tags

troubleshooting mysql



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



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


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