MySQL Performance monitoring tool: How to use Mycheckpoint

Mycheckpoint is a tool that is written in Python for performance monitoring and metrics acquisition for MySQL.

Working principle Description:

Mycheckpoint is a script that, by setting it as a crontab timed task, collects data every few minutes (limited to crontab only minutes to the basic unit) and can count the collected data and display it as a Web page.

Example effect:

For more information, see: Http://code.openark.org/forge/mycheckpoint

Steps to use:

0. Download:

wget https://mycheckpoint.googlecode.com/files/mycheckpoint-231.tar.gz

1. Create a database for Mycheckpoint

CREATE DATABASE Mycheckpoint;

2. Authorize users who are currently logged in to MySQL

GRANT  All Privileges  on Mycheckpoint. *  to ' Root '@'localhost'by'xxxx';

3. Create the database tables required by the Mycheckpoint.

    Mycheckpoint--host=127.0. 0.1 --port=3306 --user=root--password=xxxx--socket=/mysql/tmp/mysql.sock--database= Mycheckpoint

After this step, the following data table is generated in the database named: Mycheckpoint.

+------------------------------------+| Tables_in_mycheckpoint |+------------------------------------+| Alert | | alert_condition | | Alert_condition_query_view | | Alert_email_message_items_view | | alert_pending | | Alert_pending_html_view | | Alert_pending_view | | Alert_view | | Charts_api | | Custom_query | | Custom_query_top_navigation_view | | Custom_query_view | | html_components | | metadata | | Numbers | | Status_variables | | Status_variables_aggregated_day | | Status_variables_aggregated_hour | | Sv_custom_chart_day | | Sv_custom_chart_flattened_day | | Sv_custom_chart_flattened_hour | | Sv_custom_chart_flattened_sample | | Sv_custom_chart_hour | | Sv_custom_Chart_sample | | sv_custom_html | | Sv_custom_html_brief | | Sv_day | | Sv_diff | | Sv_hour | | Sv_latest | | Sv_param_change | | sv_parameter_change_union | | sv_report_24_7 | | Sv_report_24_7_minmax | | sv_report_chart_24_7 | | Sv_report_chart_day | | Sv_report_chart_day_labels | | sv_report_chart_day_timeseries | | Sv_report_chart_hour | | Sv_report_chart_hour_labels | | sv_report_chart_hour_timeseries | | Sv_report_chart_sample | | Sv_report_chart_sample_labels | | sv_report_chart_sample_timeseries | | Sv_report_day | | sv_report_day_recent | | Sv_report_day_recent_minmax | | Sv_report_hour | | sv_report_hour_recent | | Sv_report_hour_recent_Minmax | | sv_report_html | | sv_report_html_24_7 | | Sv_report_html_brief | | Sv_report_human_day | | Sv_report_human_hour | | Sv_report_human_sample | | Sv_report_sample | | sv_report_sample_recent | | sv_report_sample_recent_aggregated | | Sv_report_sample_recent_minmax | | Sv_sample |+------------------------------------+

If you accidentally designate the db of your Web app as a log database, you'll add the above data table to your web App db and delete the data table with the same name in the original web App db. It's going to be disastrous!

4. View the results in HTTP mode:

   Mycheckpoint--host=127.0. 0.1 --port=3306 --user=root--password=xxxx--socket=/mysql/tmp/mysql.sock--database= Mycheckpoint  http

When specifying a database, be careful not to use the db of your Web app.

After one hours, you can open the local http://localhost:12306/mycheckpoint to view the report.

Reviews:

The advantage of this tool is that the data can be presented in Web form, but because of its reliance on crontab, the data collection interval is too large to describe the health of MySQL well, and this tool has stopped updating in April 2014.

Other MySQL third-party tools are: Percona-toolkit and tuning-primer.sh.

Reference:

1. Http://code.openark.org/forge/mycheckpoint

2. Https://code.google.com/p/mycheckpoint/downloads/list

3.

MySQL Performance monitoring tool: How to use Mycheckpoint