07-18-2010, 08:33 PM | #1 |
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; Navicat has a server monitor GUI that helps you visualize the process list and can watch multiple servers at once. |
Reply With Quote |
Reply |
Tags |
troubleshooting mysql |
Thread Tools | |
|
|