{"id":1904,"date":"2010-02-10T08:29:47","date_gmt":"2010-02-10T06:29:47","guid":{"rendered":"http:\/\/code.openark.org\/blog\/?p=1904"},"modified":"2010-02-10T12:47:59","modified_gmt":"2010-02-10T10:47:59","slug":"mycheckpoint-rev-88-mount-points-monitoring-improved-charting-enhanced-auto-deploy","status":"publish","type":"post","link":"https:\/\/code.openark.org\/blog\/mysql\/mycheckpoint-rev-88-mount-points-monitoring-improved-charting-enhanced-auto-deploy","title":{"rendered":"mycheckpoint (rev. 88): mount points monitoring, improved charting, enhanced auto-deploy"},"content":{"rendered":"<p>Revision <a href=\"http:\/\/code.google.com\/p\/mycheckpoint\/\">#88<\/a> of <a href=\"http:\/\/code.openark.org\/forge\/mycheckpoint\">mycheckpoint<\/a> is released. In this revision:<\/p>\n<ul>\n<li>Disk space monitoring<\/li>\n<li>Improved charting<\/li>\n<li>Enhanced auto-deploy<\/li>\n<li>And more&#8230;<\/li>\n<\/ul>\n<h4>Disk space monitoring<\/h4>\n<p><em>mycheckpoint<\/em> now monitors (on Linux only) three mount points:<\/p>\n<ol>\n<li>The &#8220;<strong>\/<\/strong>&#8221; (root) mount point<\/li>\n<li>The <strong>datadir<\/strong> mount point<\/li>\n<li>The <strong>tmpdir<\/strong> mount point<\/li>\n<\/ol>\n<p>It may well be the case that two of the above (or perhaps all three of them) share the same mount point. For example, if there isn&#8217;t any particular partition for &#8220;<strong>\/tmp<\/strong>&#8220;, it is possible that the <strong>tmpdir<\/strong> (by default &#8220;<strong>\/tmp<\/strong>&#8220;) is on the same mount point as &#8220;<strong>\/<\/strong>&#8220;. <em>mycheckpoint<\/em> does not care.<\/p>\n<p><em>mycheckpoint<\/em> monitors and reports the mount point&#8217;s used percent, in a similar algorithm <strong>df<\/strong> uses.<\/p>\n<p>Disk space monitoring is only possible when monitoring the local machine (i.e. <em>mycheckpoint<\/em> runs on the same machine as the monitored MySQL server). In the future <em>mycheckpoint<\/em> may also monitor additional mount points, such as the various logs mount points.<\/p>\n<h4><!--more-->Improved charting<\/h4>\n<p>There has been some extensive work to turn the charts into real time-series based. <a href=\"http:\/\/code.google.com\/apis\/chart\/\">Google charts<\/a> does not support time series charts; when it will, the required URL length would probably be too long to be used. Some SQL tweaks made it possible to display the charts in correct time-scale even if sampling is taken on non constant interval (or fail to be taken for long periods).<\/p>\n<blockquote><p><a href=\"http:\/\/code.openark.org\/blog\/wp-content\/uploads\/2010\/02\/mycheckpoint-dml-chart-sample-88.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1951\" title=\"mycheckpoint-dml-chart-sample-88\" src=\"http:\/\/code.openark.org\/blog\/wp-content\/uploads\/2010\/02\/mycheckpoint-dml-chart-sample-88.png\" alt=\"\" width=\"400\" height=\"200\" srcset=\"https:\/\/code.openark.org\/blog\/wp-content\/uploads\/2010\/02\/mycheckpoint-dml-chart-sample-88.png 400w, https:\/\/code.openark.org\/blog\/wp-content\/uploads\/2010\/02\/mycheckpoint-dml-chart-sample-88-300x150.png 300w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/a><\/p><\/blockquote>\n<p>For more examples see the link for <em>HTML brief reports<\/em> sample, below.<\/p>\n<p>I will write more on SQL Google charts generation in the future.<\/p>\n<h4>Enhanced auto-deploy<\/h4>\n<p><em>mycheckpoint<\/em> will now detect changes to the MySQL version, in addition to changes in <em>mycheckpoint<\/em>&#8216;s version itself. This means there&#8217;s no need in ever worrying about upgrades to either one of these components. Just use mycheckpoint to take another sample; it will auto-detect if the MySQL version is different, and start sampling all those new variables introduced in the new version (or stop sampling variables no longer used). It works both for MySQL upgrades and downgrades.<\/p>\n<h4>Enhanced localhost detection<\/h4>\n<p>To determine whether it is monitoring the local host, <em>mycheckpoint<\/em> now considers the hostname for the monitored server, and sees if it is either <strong>&#8216;127.0.0.1&#8217;<\/strong>, <strong>&#8216;localhost&#8217;<\/strong>, or the machine&#8217;s <em>hostname<\/em> or fully qualified <em>hostname.domainname<\/em> (these last two additions apply for Unix based machines, and have only been tested on Linux so far).<\/p>\n<h4>HTML brief reports<\/h4>\n<p>Getting a full HTML report is time consuming. I&#8217;ve had requests (though not officially submitted through the Issues mechanism) to make it shorter. This is as yet a difficult job. There&#8217;s just too much data to aggregate (up to ~180 days of every-5-minute-samples, in a common scenario).<\/p>\n<p>HTML <em>brief reports<\/em> were introduced in previous versions, and have now been enhanced to include more data. These only present last 24 hours data, and load fast. See <a href=\"http:\/\/code.openark.org\/blog\/wp-content\/uploads\/2010\/02\/mycheckpoint-brief-report-sample-88.html\">HTML brief report sample<\/a>.<\/p>\n<h4>Get it<\/h4>\n<p>Downloads are available on Google code&#8217;s <a href=\"http:\/\/code.google.com\/p\/mycheckpoint\/\">mycheckpoint<\/a> page. Documentation can be found on the <a href=\"http:\/\/code.openark.org\/forge\/mycheckpoint\/\">mycheckpoint home page<\/a>.<\/p>\n<h4>On the press<\/h4>\n<p>Not so new by now (it&#8217;s two months old), I&#8217;m very happy that mycheckpoint has been noted by <a href=\"http:\/\/jeremy.zawodny.com\/blog\/\"><strong>Jeremy Zawodny<\/strong><\/a> in his &#8220;<a href=\"http:\/\/www.linux-mag.com\/cache\/7639\/1.html\">My Top Resources of 2009<\/a>&#8221; column on Linux Magazine.<\/p>\n<h4>Future plans<\/h4>\n<p>Immediate plans for mycheckpoint are:<\/p>\n<ul>\n<li>Email alerts notifications; this will allow <em>mycheckpoint<\/em> to become a real monitoring solution. Following the concept of &#8220;<em>SQL oritented monitoring<\/em>&#8220;, these will be SQL based as well.<\/li>\n<li>Custom monitoring: allowing user defined queries to be recorded by <em>mycheckpoint<\/em>; these can then participate in alerts monitoring. This will allow for easy email notifications on program-level errors.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Revision #88 of mycheckpoint is released. In this revision: Disk space monitoring Improved charting Enhanced auto-deploy And more&#8230; Disk space monitoring mycheckpoint now monitors (on Linux only) three mount points: The &#8220;\/&#8221; (root) mount point The datadir mount point The tmpdir mount point It may well be the case that two of the above (or [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[5],"tags":[41,46,49],"class_list":["post-1904","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-graphs","tag-monitoring","tag-mycheckpoint"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2bZZp-uI","_links":{"self":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/1904","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/comments?post=1904"}],"version-history":[{"count":14,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/1904\/revisions"}],"predecessor-version":[{"id":1958,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/1904\/revisions\/1958"}],"wp:attachment":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/media?parent=1904"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/categories?post=1904"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/tags?post=1904"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}