Consolidate main system and MySQL health metrics in one report.
Commad-line tool provides the following details in the report:
- 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
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:
....
DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc.
AI-powered service management for IT and enterprise teams
Enterprise-grade ITSM, for every business
Give your IT, operations, and business teams the ability to deliver exceptional services—without the complexity. Maximize operational efficiency with refreshingly simple, AI-powered Freshservice.