輕量級面向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