GitHub - vlad-github/mysql-health-check: Provides MySQL load type, key statistics, slow queries report and other health information

vlad-github / mysql-health-check Public

Notifications You must be signed in to change notification settings
Fork 28
Star 61

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

61 stars 28 forks Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 88 Commits
bin		bin
mysql_counters		mysql_counters
mysql_query_review		mysql_query_review
.gitignore		.gitignore
README		README
check_run.sh		check_run.sh
crontab.txt		crontab.txt
first_look.sh		first_look.sh
mysql_health_check.sh		mysql_health_check.sh

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!