| Name | Modified | Size | Downloads / Week |
|---|---|---|---|
| mysql-health-check-0.6.2b.tar.gz | 2015-01-15 | 184.3 kB | |
| README | 2015-01-06 | 1.9 kB | |
| Totals: 2 Items | 186.1 kB | 0 |
#### THE GOAL
Consolidate main MySQL and system health metrics in one report.
Useful for routine daily and weekly MySQL checks.
Report provides:
- Basic OS-level parameters: uptime, disk space and network interface status
- Today's entries from MySQL error log
- Important MySQL statistics http://astellar.com/mysql-health-check/metrics/
- Top 5 queries from MySQL slow query log
Report example: http://astellar.com/mysql-health-check/report-sample/
#### CONFIGURING AND RUNNING
1. Edit MySQL credentials in check_run.sh
2. Run ./check_run.sh
3. Enjoy!
You can also send report to email address by using --email parameter:
./check_run.sh --email <your@email.com>
Report will be emailed to you. Useful when running script via cron.
#### FIRST LOOK MODE
You can collect all the important information about the MySQL server
and operating system environment by running
./check_run.sh --first-look
Report includes most information about your Operating system,
MySQL server and your DB schema. Please check for more details:
http://astellar.com/mysql-health-check/initial-review-mode/
#### DOCUMENTATION
http://astellar.com/mysql-health-check/
This project based on Percona Toolkit:
http://www.percona.com/software/percona-toolkit
#### DOWNLOAD LATEST
From GitHub: https://github.com/vlad-github/mysql-health-check
From SourceForge:
wget http://sourceforge.net/projects/mysql-health-check/files/latest/download
#### REQUIREMENTS
Software required on RHEL/CentOS:
yum install php-cli php-mysql perl-Time-HiRes
Software required on Ubuntu/Debian:
apt-get install php5-cli php5-mysqlnd
mailutils can also be required.
Have a nice day!