☰
✕
✕

How to Monitor Mysql Database Using Mytop on Oracle Linux 8.5

To Monitor MySQL Database using Mytop on Oracle Linux 8.5

Introduction:

Mytop is an open-source, command line tool utilized for monitoring MySQL performance. Mytop connects to a MySQL server and periodically executes the show process list and show global status commands. It then summarizes the information in a useful format. Using Mytop, we can monitor (in real-time) MySQL threads, queries, and uptime as well as see which user is running queries on which database, which are the slow queries, and more. All this information can be used to optimize the MySQL server performance.

Procedure:

Step 1: Check the Version of OS by using the below command

[root@linuxhelp ~]# cat /etc/os-release
NAME="Oracle Linux Server"
VERSION="8.5"
ID="ol"
ID_LIKE="fedora"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="8.6"
PLATFORM_ID="platform:el8"

Step 2: Install mytop using the below command

[root@linuxhelp ~]# yum install mytop
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: centos.excellmedia.net
 * extras: centos.excellmedia.net
 * rpmforge: mirror1.hs-esslingen.de
 * updates: centos.excellmedia.net
lxcenter-updates                                                                                          | 2.5 kB     00:00     
Resolving Dependencies
.
.
.
Running Transaction
  Installing : mytop-1.7-3.b737f60.el6.noarch                                                                                1/1
  Verifying  : mytop-1.7-3.b737f60.el6.noarch                                                                                1/1

Installed:
  mytop.noarch 0:1.7-3.b737f60.el6     
                                                                                         
Complete!

Step 3: Monitor MySQL using Mytop Run by using the below command and start the Mytop shell and provide your root MySQL password when required.

[root@linuxhelp ~]# mytop --prompt
Password:

Step 4: Once you enter your password, Mytop monitoring shell window appears as below.

Step 5: Monitor specific database Use -d option if you want to monitor specific database use the below command

[root@linuxhelp~]# mytop --prompt -d movies

Conclusion:

We have reached the end of this article. In this guide, we have walked you through the steps required to to Monitor MySQL Database using Mytop on Oracle Linux 8.5. Your feedback is much welcome.

Tag : Mytop MySQL Database OracleVM
FAQ
Q
What is the default configuration file for "mytop" package in Linux?
A
Here I have to mention the default configuration file for "mytop" command. File: "~/.mytop"
Q
How do I know the entire functionality of "mytop" command?
A
You can use the option of "--help" with "mytop" (or) "man" page of "mytop" command to know the entire functionality of "mytop" command. For Ex: "mytop --help" (or) "man mytop".
Q
How to run the "Mytop" command using any specified user privilege?
A
You can use the following syntax to run the "Mytop" command using any specified user privilege. For Syntax: "mytop -u username –p"
Q
How to install "Mytop" on CentOS?
A
You can follow the steps as below, to install the "Mytop" package on CentOS. Syntax: "yum install epel-release" "yum install mytop –y"
Q
How to monitor a specific database using the "mytop" command in Linux?
A
You can use see the syntax to monitor a specific database using the "Mytop" command in Linux. Syntax: "mytop -prompt -d "DBname"