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. |
All times are GMT -4. The time now is 07:12 PM. |
Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2024, vBulletin Solutions, Inc.