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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
