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