{"id":133,"date":"2009-10-23T11:22:44","date_gmt":"2009-10-23T09:22:44","guid":{"rendered":"http:\/\/code.openark.org\/forge\/?page_id=133"},"modified":"2010-11-08T12:24:38","modified_gmt":"2010-11-08T10:24:38","slug":"mycheckpoint","status":"publish","type":"page","link":"https:\/\/code.openark.org\/forge\/mycheckpoint","title":{"rendered":"mycheckpoint"},"content":{"rendered":"<h4><em>Lightweight, SQL oriented monitoring for MySQL<\/em><\/h4>\n<p><em>mycheckpoint<\/em> is an open source monitoring utility for MySQL, with strong emphasis on user accessibility to monitored data.<\/p>\n<p>It is <em>SQL oriented<\/em>: charts, reports and advances metrics are generated on the fly with views.<\/p>\n<p><em>mycheckpoint<\/em> highlights:<\/p>\n<ul>\n<li>Can act as web server (see <a href=\"http:\/\/mycheckpoint.googlecode.com\/svn\/trunk\/doc\/html\/sample\/http\/mcp_sql00\/sv_report_html_brief\">sample<\/a>), providing with live HTML reports. It does not have to: it is not a web-based solution.<\/li>\n<li>Records MySQL status &amp; variables.<\/li>\n<li>Records OS (Linux) metrics, such as load average, swap activity, etc.<\/li>\n<li>Allows for <a href=\"..\/mycheckpoint\/documentation\/custom-monitoring\">custom queries<\/a>, the results of which are aggregated along with all other measurements.<\/li>\n<li>Supports <a href=\"..\/mycheckpoint\/documentation\/alerts\">alert conditions<\/a>, with <a href=\"..\/mycheckpoint\/documentation\/emails\">email<\/a> notifications on on raised or resolved alerts.<\/li>\n<li>On the fly <a href=\"mycheckpoint\/documentation\/generating-html-reports\">HTML reports generation<\/a> (see <a href=\"http:\/\/mycheckpoint.googlecode.com\/svn\/trunk\/doc\/html\/sample\/http\/mcp_sql00\/sv_report_html\">sample<\/a>). HTML is issued by a query, resulting with complete HTML, JavaScript based charts and data.<\/li>\n<li>On the fly <a href=\"mycheckpoint\/documentation\/generating-google-charts\">chart generation<\/a>; charts utilize the Google Chart API.<\/li>\n<li>Generation of <a href=\"mycheckpoint\/documentation\/generating-human-reports\">human readable reports<\/a>.<\/li>\n<li><a href=\"mycheckpoint\/documentation\/detecting-parameters-change\">Parameters change<\/a> detection.<\/li>\n<li>SQL access to data via <a href=\"mycheckpoint\/documentation\/querying-for-data\">simple SELECT statements<\/a>.<\/li>\n<\/ul>\n<p>Please refer to the <a href=\"mycheckpoint\/documentation\">documentation<\/a> for further discussion (or just use the <a href=\"http:\/\/code.openark.org\/forge\/mycheckpoint\/documentation\/quick-howto\">Quick HOWTO<\/a>), or to the <a href=\"mycheckpoint\/download\">download<\/a> page for obtaining <em>mycheckpoint<\/em>.<\/p>\n<blockquote>\n<pre>SELECT innodb_read_hit_percent, DML FROM sv_report_chart_sample;<\/pre>\n<\/blockquote>\n<blockquote><p><img loading=\"lazy\" decoding=\"async\" title=\"mycheckpoint-innodb-read-hit-chart-sample-88.png\" src=\"http:\/\/code.openark.org\/forge\/wp-content\/uploads\/2010\/02\/mycheckpoint-innodb-read-hit-chart-sample-88.png\" alt=\"mycheckpoint-innodb-read-hit-chart-sample-88\" width=\"400\" height=\"200\" \/><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-294\" title=\"mycheckpoint-dml-chart-sample-88.png\" src=\"http:\/\/code.openark.org\/forge\/wp-content\/uploads\/2010\/02\/mycheckpoint-dml-chart-sample-88.png\" alt=\"mycheckpoint-dml-chart-sample-88\" width=\"400\" height=\"200\" \/><\/p><\/blockquote>\n<p><em>Above: querying for Google Chart URLs for measured metrics<\/em><\/p>\n<p><em>Below: querying for human readable hourly report<\/em><\/p>\n<blockquote>\n<pre>SELECT report FROM sv_report_human_hour ORDER BY id DESC LIMIT 1,1 \\G<\/pre>\n<\/blockquote>\n<blockquote>\n<pre>Report period: 2010-02-10 08:00:00 to 2010-02-10 09:00:00. Period is 60 minutes (1.00 hours)\r\nUptime: 100% (Up: 379 days, 02:12:28 hours)\r\n\r\nOS:\r\n Load average: 2.70\r\n CPU utilization: 17.8%\r\n Memory: 7470.1MB used out of 8177.3MB (Active: 6920.9MB)\r\n Swap: 4319.2MB used out of 8385.9MB\r\n\r\nInnoDB:\r\n innodb_buffer_pool_size: 4718592000 bytes (4500.0MB). Used: 100.0%\r\n Read hit: 99.92%\r\n Disk I\/O: 15.07 reads\/sec\u00a0 22.89 flushes\/sec\r\n Estimated log written per hour: 809.3MB\r\n Locks: 0.13\/sec\u00a0 current: 0\r\n\r\nMyISAM key cache:\r\n key_buffer_size: 33554432 bytes (32.0MB). Used: 18.2%\r\n Read hit: 99.8%\u00a0 Write hit: 100.0%\r\n\r\nDML:\r\n SELECT:\u00a0 82.97\/sec\u00a0 13.0%\r\n INSERT:\u00a0 66.70\/sec\u00a0 10.5%\r\n UPDATE:\u00a0 19.24\/sec\u00a0 3.0%\r\n DELETE:\u00a0 16.95\/sec\u00a0 2.7%\r\n REPLACE: 0.00\/sec\u00a0 0.0%\r\n SET:\u00a0\u00a0\u00a0\u00a0 158.79\/sec\u00a0 24.9%\r\n COMMIT:\u00a0 0.03\/sec\u00a0 0.0%\r\n slow:\u00a0\u00a0\u00a0 0.02\/sec\u00a0 0.0% (slow time: 1sec)\r\n\r\nSelects:\r\n Full scan: 5.69\/sec\u00a0 6.9%\r\n Full join: 0.00\/sec\u00a0 0.0%\r\n Range:\u00a0\u00a0\u00a0\u00a0 0.84\/sec\u00a0 1.0%\r\n Sort merge passes: 0.00\/sec\r\n\r\nLocks:\r\n Table locks waited:\u00a0 0.00\/sec\u00a0 0.0%\r\n\r\nTables:\r\n Table cache: 2048. Used: 88.5%\r\n Opened tables: 0.00\/sec\r\n\r\nTemp tables:\r\n Max tmp table size:\u00a0 67108864 bytes (64.0MB)\r\n Max heap table size: 67108864 bytes (64.0MB)\r\n Created:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6.15\/sec\r\n Created disk tables: 0.18\/sec\u00a0 2.8%\r\n\r\nConnections:\r\n Max connections: 200. Max used: 245\u00a0 122.5%\r\n Connections: 2.67\/sec\r\n Aborted:\u00a0\u00a0\u00a0\u00a0 0.07\/sec\u00a0 2.6%\r\n\r\nThreads:\r\n Thread cache: 32. Used: 68.8%\r\n Created: 0.02\/sec\r\n\r\nReplication:\r\n Master status file number: 2241, position: 524487864\r\n Relay log space limit: 10737418240, used: N\/A\u00a0 (N\/A%)\r\n Seconds behind master: N\/A\r\n Estimated time for slave to catch up: N\/A seconds (N\/A days, N\/A hours)\u00a0 ETA: N\/A\r\n<\/pre>\n<\/blockquote>\n<p><em>mycheckpoint<\/em> is released under the <a href=\"http:\/\/www.opensource.org\/licenses\/bsd-license.php\">BSD license<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-133","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/pages\/133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/comments?post=133"}],"version-history":[{"count":38,"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/pages\/133\/revisions"}],"predecessor-version":[{"id":150,"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/pages\/133\/revisions\/150"}],"wp:attachment":[{"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/media?parent=133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}