Dedicated Server How to track MySQL Load

Dedicated Server How to track MySQL Load
Dedicated Server How to track MySQL Load

If you notice that the MySQL processes on dedicated server are using a lot of CPU load, there is a way to see which MySQL user is causing it.

  1. Display the user/pass by running:
cat /usr/local/directadmin/conf/mysql.conf
  1. Login to /phpMyAdmin through Apache (any website)
  2. Click the “Processes” tab (near top right), or if you don’t have Processes tab, click the “SQL” tab, and run the query

A query shouldn’t take anymore than few seconds. Queries that take more than that are likely the source of the high load on the box.

The “Processes” tab has the option to kill a process, if needed. Using it may cause corrupted databases, so use sparingly.

If you find a specific User which is using more load than he should, newer MySQL versions have the ability to limit resources. As of DA 1.37.0, this feature is not in the interface, but if you login to /phpMyAdmin again (see #2 above), go to the database mysql then the table user and edit the user in question, and adjust the options:

Don’t have dedicated server? get your own here

Leave A Comment

What’s happening in your mind about this post !

Your email address will not be published. Required fields are marked *