基于python实现的Mysql数据库性能监测工具

# MySQL_Watcher MySQL Watcher is a tool to help DBA's to trouble shoot MySQL performance. pip install psutil pip install prettytable 2.7： pip install mysql-python 3.8: pip install mysqlclient Some options must be executed on the host,not remote. The MySQL sys schema support now. https://github.com/mysql/mysql-sys Some sys view is off by default, you can set in the dbset.ini. example:   Edit MySQL connect info in dbset.ini. execute: 2.7: python mysql_watcher.py python mysql_watcher.py -p dbset.ini python mysql_watcher.py -p dbset.ini -s txt >mysql_watcher.txt python mysql_watcher.py -p dbset.ini -s html >mysql_watcher.html send email: python SendEmail.py -p emailset.ini -f my_report1.html,my_report2.html 3.8: python3 mysql_watcher3.py python3 mysql_watcher3.py -p dbset.ini python3 mysql_watcher3.py -p dbset.ini -s txt >mysql_watcher.txt python3 mysql_watcher3.py -p dbset.ini -s html >mysql_watcher.html send email: python3 SendEmail3.py -p emailset.ini -f my_report1.html,my_report2.html use crontab regularly perform sql_report.sh,auto generate report,and send email. Enjoy it! ## 好用的DBA系列，喜欢的打颗星： - [MySQL_Watcher：数据库性能指标的HTML监控报告](https://github.com/kinghows/MySQL_Watcher) - [SQL_Report：自定义SQL生成HTML报告](https://github.com/kinghows/SQL_Report) - [SQL_Chart：自定义SQL生成HTML图表](https://github.com/kinghows/SQL_Chart) - [Logthin：日志精简工具](https://github.com/kinghows/Logthin) - [Logchart：日志图形化工具](https://github.com/kinghows/Logchart) - [Linux_Report：自定义Linux 命令生成HTML报告](https://github.com/kinghows/Linux_Report)