myTop – mySQL – Database – Performance Monitoring Tool

mysql-tutorials

myTop is one of free open source code to monitor mySQL Database in CUI mode. The terminal window show the statistics information about threads queries, uptime and more etc.., The tool helps to optimize and improve performance of mySQL to handle large request and response in the database server.

How to install myTOP in Ubuntu ?

sudo apt install mytop

Configuring myTOP

sudo nano /root/.mytop

Copy and paste the default settings.

host=localhost
db=mysql
delay=3
port=3306
socket=
batchmode=0
color=1
idle=0

Connecting to myTOP :-

sudo mytop -u <<USERNAME> –prompt

Sample myTOP terminal window :-

mysql-mytop-database-monitoring-tool

Related posts

Leave a Comment