Mytop can be used to monitor MySQL.

Installation of Mytop

1) Sign in to the server as the root user via SSH.

For centOS

2) Execute the following command to install the EPEL repository.

# yum install epel-release

To confirm whether the yum repository list has been updated or not, the following command can be used

# yum repolist

Since we have updated the EPEL repository on the server, install the Mytop package using the EPEL repository with the following command.

# yum install mytop –y

After the installation, we need to configure Mytop. We can configure Mytop by modifying the customized file .mytop. To create the configuration file, open that file and add the details mentioned below.

For Ubuntu

To install Mytop, run the following command.

# apt-get install mytop

# vi ~/.mytop

host=localhost

db=mysql

delay=10

port=3306

socket=

batchmode=0

color=1

idle=2

Now Mytop is successfully configured. You can also make changes to this configuration file according to your requirements. For instance, the delay option specifies the interval, in seconds, between display refreshes.

If you enter delay=5, then the monitor tab will refresh every 5 seconds.

The idle parameter allows sleeping threads to appear in the list on the Mytop display screen. The default is to show idle threads. If you want to exclude the idle threads, then set idle=0. In that case, the default sorting order is reversed so that the longest running queries appear at the top of the list.

Connecting to my Top

The following command is used to check the performance of MySQL where –prompt is used to prompt for the mysql database password. Enter the password and then you can monitor mysql.

# mytop –prompt

Now we will use the specific user to execute the Mytop command

# mytop -u root –p

If you want to monitor a specific database, use the -d option as shown below. For example, the following command will monitor the database “db”.

# mytop –prompt -d db

You can also find more switches from the following command.

#man mytop

Now you have a good understanding of how to use Mytop to observe your MySQL server. It is also a starting point for identifying problematic SQL queries and optimizing them, thereby enhancing the overall performance of the server.

If you require any further assistance, please reach out to our support department.