Vlad Fedorkov

Performance consulting for MySQL and Sphinx

MySQL Health Check Script

Download : Installation : Sample report : Metrics : Full review

MySQL Health Checker is a simple scripts that provide MySQL and OS metrics, slow queries and MySQL errors in one report.
Features

  • Key MySQL metrics highlights (check the report)
  • Shows recent MySQL error log entries
  • Shows Top 5 Slow Queries from MySQL slow log
  • Complete MySQL instance information collection with –first-look mode
  • Command-line style. Cron compatible.
  • Open source. Available on GitHub and SourceForge

What it does?

It’s calculating MySQL instance parameters like read/write rate, indicating metrics related to potential performance issues like full table scans, temporary tables creation, locks and some storage-level IO-stats.

Yet another script. Why?

Idea was to automate daily DBA routine checks and see what’s going on on MySQL servers without having to log in and enter same commands manually day-by-day. Working with customers systems year by year I come up the set of metrics that in addition to monitoring will indicate current MySQL and system state and allow to detect possible issues before they become a problem.

Report includes basic but important system-wide metrics like free space and memory consumption and amount of per-interface network errors (in netstat output). MySQL side starts with recent entries from MySQL error log, list of important MySQL statistics along with load statistics and query cache metrics (where enabled) and most important – slow query report generated using great tool called pt-query-digest from Percona Toolkit. This report will be created automatically if you have slow query log enabled and non-empty.

Complete data collection mode

This tool also allows you to collect most of the available MySQL performance counters, OS & MySQL configuration and database schema details by running in –first-look mode. Results stored as set of files. Useful for performance troubleshooting.

Usage and download

This tool can run from shell or send a report via email (good for cron). Please feel free to download this tool from GitHub or SourceForge. Installation and configuration instructions are here. If you have any concerns regarding your MySQL servers health please feel free to drop me a note.

If you like this tool – please share it!

  • Monroe says:

    Nice post. I was checking continuously this weblog and I’m impressed!
    Very useful information particularly the ultimate part :
    ) I maintain such information much. I used to be
    seeking this certain info for a long time. Thanks and good luck.

    January 18, 2016 at 5:26 pm
  • click here says:

    Thanks for sharing your thoughts about repaired.
    Regards

    September 5, 2017 at 6:17 pm
  • pengeluaran sgp says:

    Di Kunjungi Situs Pengeluaran Sgp
    Dan Data Sgp Tercepat , terakuran,
    dan terupdate di dunia.
    Data Sgp

    Data Sgp

    September 28, 2019 at 7:12 pm
  • balagaanesh says:

    I checked the scripts ,but it is not working in my case . Because we are connecting the DB using the alias,,,how to modify the scripts

    October 19, 2019 at 8:06 pm
  • forum judi online terpercaya says:

    I have read so many articles regarding the blogger lovers except this piece
    of writing is truly a pleasant article, keep it up.

    December 16, 2019 at 7:21 am
  • Lavada says:

    The user doеs noot want to wste tіmе giving informatiⲟn that isn’t neϲessary.

    There are basically tѡo types ⲟf options ɑvailable to thе individuals.
    Professionalized experts аnd members of friendship
    helps at еvery step ɑnd providing creative ɑnd effective solutions to build your site
    online.

    January 24, 2020 at 10:19 am
  • Www.metodista.br says:

    First off I want to say great blog! I had a quick
    question which I’d like to ask if you don’t mind. I was interested
    to know how you center yourself and clear your
    thoughts before writing. I have had difficulty clearing my thoughts in getting
    my ideas out. I do take pleasure in writing but it just seems like
    the first 10 to 15 minutes are wasted simply just trying to figure out how to begin. Any suggestions or hints?
    Appreciate it!https://Www.metodista.br/revistas/revistas-ims/index.php/ER/comment/view/7103/0/627496

    February 3, 2020 at 5:42 pm
  • Edith says:

    My brother recommended I might like this blog. He was totally right.
    This put up truly made my day. You can not believe just how a
    lot time I had spent for this information! Thanks!

    April 4, 2020 at 11:14 pm

Your email address will not be published. Required fields are marked *

*