Lightweight, SQL oriented monitoring for MySQL
mycheckpoint is an open source monitoring utility for MySQL, with strong emphasis on user accessibility to monitored data.
It is SQL oriented: charts, reports and advances metrics are generated on the fly with views.
- Can act as web server (see sample), providing with live HTML reports. It does not have to: it is not a web-based solution.
- Records MySQL status & variables.
- Records OS (Linux) metrics, such as load average, swap activity, etc.
- Allows for custom queries, the results of which are aggregated along with all other measurements.
- Supports alert conditions, with email notifications on on raised or resolved alerts.
- On the fly chart generation; charts utilize the Google Chart API.
- Generation of human readable reports.
- Parameters change detection.
- SQL access to data via simple SELECT statements.
SELECT innodb_read_hit_percent, DML FROM sv_report_chart_sample;
Above: querying for Google Chart URLs for measured metrics
Below: querying for human readable hourly report
SELECT report FROM sv_report_human_hour ORDER BY id DESC LIMIT 1,1 \G
Report period: 2010-02-10 08:00:00 to 2010-02-10 09:00:00. Period is 60 minutes (1.00 hours) Uptime: 100% (Up: 379 days, 02:12:28 hours) OS: Load average: 2.70 CPU utilization: 17.8% Memory: 7470.1MB used out of 8177.3MB (Active: 6920.9MB) Swap: 4319.2MB used out of 8385.9MB InnoDB: innodb_buffer_pool_size: 4718592000 bytes (4500.0MB). Used: 100.0% Read hit: 99.92% Disk I/O: 15.07 reads/sec 22.89 flushes/sec Estimated log written per hour: 809.3MB Locks: 0.13/sec current: 0 MyISAM key cache: key_buffer_size: 33554432 bytes (32.0MB). Used: 18.2% Read hit: 99.8% Write hit: 100.0% DML: SELECT: 82.97/sec 13.0% INSERT: 66.70/sec 10.5% UPDATE: 19.24/sec 3.0% DELETE: 16.95/sec 2.7% REPLACE: 0.00/sec 0.0% SET: 158.79/sec 24.9% COMMIT: 0.03/sec 0.0% slow: 0.02/sec 0.0% (slow time: 1sec) Selects: Full scan: 5.69/sec 6.9% Full join: 0.00/sec 0.0% Range: 0.84/sec 1.0% Sort merge passes: 0.00/sec Locks: Table locks waited: 0.00/sec 0.0% Tables: Table cache: 2048. Used: 88.5% Opened tables: 0.00/sec Temp tables: Max tmp table size: 67108864 bytes (64.0MB) Max heap table size: 67108864 bytes (64.0MB) Created: 6.15/sec Created disk tables: 0.18/sec 2.8% Connections: Max connections: 200. Max used: 245 122.5% Connections: 2.67/sec Aborted: 0.07/sec 2.6% Threads: Thread cache: 32. Used: 68.8% Created: 0.02/sec Replication: Master status file number: 2241, position: 524487864 Relay log space limit: 10737418240, used: N/A (N/A%) Seconds behind master: N/A Estimated time for slave to catch up: N/A seconds (N/A days, N/A hours) ETA: N/A
mycheckpoint is released under the BSD license.