mysql监控某一张表_mysql常用监控脚本命令列表

#/bin/sh

#检测mysql server是否正常提供服务

mysqladmin -u sky -ppwd -h localhost ping

#获取mysql当前的几个状态值

mysqladmin -u sky -ppwd -h localhost status

#获取数据库当前的连接信息

mysqladmin -u sky -ppwd -h localhost processlist

#获取当前数据库的连接数

mysql -u root -p123456 -BNe "select host,count(host) from processlist group by host;" information_schema

#显示mysql的uptime

mysql -e"SHOW STATUS LIKE '%uptime%'"|awk '/ptime/{ calc = $NF / 3600;print $(NF-1), calc"Hour" }'

#查看数据库的大小

mysql -u root -p123456-e 'select table_schema,round(sum(data_length+index_length)/1024/1024,4) from information_schema.tables group by table_schema;'

#查看某个表的列信息

mysql -u --password= -e "SHOW COLUMNS FROM

#执行mysql脚本

mysql -u user-name -p password < script.sql

#mysql dump数据导出

mysqldump -uroot -