轻量级面向SQL的MySQL开源监控工具

2024-04-28 08:19•服务端开发•阅读 1267

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.

mycheckpoint highlights:

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 HTML reports generation (see sample). HTML is issued by a query, resulting with complete HTML, JavaScript based charts and data.
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.

mycheckpoint 是一个开源的 MySQL 监控工具，主要用来监控数据。通过视图方式提供监控数据报表。mycheckpoint 支持以独立的Web服务器来运行。