MySQL 监控工具 mytop,mtop,innotop,mysqlreport,mysqltuner

netkiller-

于 2024-08-31 00:22:42 发布

阅读量1.8k

点赞数 16

分类专栏：数据库手札运维手札文章标签：数据库 mysql mariadb

本文链接：https://blog.csdn.net/u010604770/article/details/141730161

版权

MySQL 监控工具 mytop,mtop,innotop,mysqlreport,mysqltuner

1.9.1.1. mytop - top like query monitor for MySQL

sudo apt-get install mytop

mytop --host=172.16.0.7 --user=monitor --password=your_passwd

1.9.1.2. mtop - MySQL terminal based query monitor

http://mtop.sourceforge.net/

sudo apt-get install mtop
mtop --host=172.16.0.6 --dbuser=monitor --password=your_passwd

mkill

mkill -sl 180 -fi 'select.*from bad_table' > /var/log/mkill.out 2> /var/log/mkill.kill

1.9.1.3. innotop

1.9.1.4. mysqlreport - A friendly report of important MySQL status values

# yum install mysqlreport -y

wget hackmysql.com/scripts/mysqlreport

		
[root@database ~]# mysqlreport --user root --password chen
Use of uninitialized value in multiplication (*) at /usr/bin/mysqlreport line 829.
Use of uninitialized value in formline at /usr/bin/mysqlreport line 1227.
MySQL 5.0.77-log         uptime 28 23:42:33     Sat Apr 10 18:15:44 2010

__ Key _________________________________________________________________
Buffer used     6.54M of   8.00M  %Used:  81.75
  Current       1.49M            %Usage:  18.58
Write hit      97.65%
Read hit       99.81%

__ Question