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 db=mysql delay=3 port=3306 socket= batchmode=0 color=1 idle=1
This is a personalized configuration that will be used during the execution of the program.
To run it, we need to type in the following command:
$ sudo mytop --prompt
Then we need to type...