Friday, February 19, 2021

how to install mytop in ubuntu

Mytop is an open source, command line tool used for monitoring MySQL performance. It was inspired by the Linux system monitoring tool named top and is similar to it in look and feel. Mytop connects to a MySQL server and periodically runs the show processlist and show global status commands

Step 1) Install mytop in ubuntu 16.04

$ sudo apt-get install mytop

Step 2) Move into root directory 

$ cd /root

Step 3) Edit a file as named (.mytop) and add follwing syntax 

vim .mytop

user=root
pass=mysql_password
host=localhost
db=mysql
delay=1
port=3306
socket=
batchmode=0
header=1
color=1
idle=1

Step 4) Run mytop command and moniter

$ mytop

No comments:

Post a Comment

testing