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:

./check_run.sh --email <your@email.com>

Report will be emailed to you. Useful when running script via cron.

Features

  • Highliting key metrics from MySQL server
  • Showing recent MySQL error log entries
  • Summarizing slow query report using Percona Toolkit
  • Cron-compatible command-line style

Project Samples

MySQL statistics overview

Project Activity

See All Activity >

Categories

Database, Systems Administration

License

BSD License

Follow MySQL Health Report

MySQL Health Report Web Site

Other Useful Business Software
AI-powered service management for IT and enterprise teams Icon
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.
Try it Free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of MySQL Health Report!

Additional Project Details

Operating Systems

BSD, FreeBSD, Linux

Languages

English

Intended Audience

Auditors, Information Technology, Quality Engineers, System Administrators

User Interface

Command-line

Programming Language

PHP, Unix Shell

Database Environment

MySQL

Related Categories

Unix Shell Database Software, Unix Shell Systems Administration Software, PHP Database Software, PHP Systems Administration Software

Registered

2014-11-19
Report inappropriate content