Configuring Mytop for a MySQL database

Mytop is an open source solution that helps monitor the MySQL database's activities and performance, or what we now know as MariaDB for CentOS 7. It is a non-GUI monitoring tool. Therefore, it kind of provides an interphase through the shell command line.

To install Mytop, we should make sure that the installation is going to be at the same server where the MariaDB database server is installed. Then we add the EPEL repository, as follows:

$ sudo yum install epel-release

Next, we execute the installation using yum:

$ sudo yum install mytop

For the configuration, we only need to create a configuration file at the root folder:

$ sudo nano /root/.mytop

Then we type the following text inside it:

host=localhost ...

Get Mastering CentOS 7 Linux Server now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.