摘要:
#/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;" 阅读全文