Skip to content

Provides MySQL load type, key statistics, slow queries report and other health information

Notifications You must be signed in to change notification settings

li-jun-fei/mysql-health-check

 
 

Repository files navigation

#### 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/
    
    You could run this type of review remotelly (key-based ssh acess 
    is requred) using

       ./check_run.sh --remote <hostname>
    
    resuling .tar.gz will be copied back to current directory.
    This mode is convenient for reivew of multiple MySQL servers.

#### 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!

About

Provides MySQL load type, key statistics, slow queries report and other health information

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Perl 70.4%
  • Shell 28.3%
  • Other 1.3%