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

mycheckpoint

http://code.openark.org/forge/mycheckpoint

 

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服务器来运行。

查看详细报表示例。

安装手册：http://code.openark.org/forge/mycheckpoint/documentation/installation