{"id":4568,"date":"2011-12-18T08:48:10","date_gmt":"2011-12-18T06:48:10","guid":{"rendered":"http:\/\/code.openark.org\/blog\/?p=4568"},"modified":"2011-12-18T08:48:10","modified_gmt":"2011-12-18T06:48:10","slug":"monitor-your-mysql-servers-as-done-before-for-free","status":"publish","type":"post","link":"https:\/\/code.openark.org\/blog\/mysql\/monitor-your-mysql-servers-as-done-before-for-free","title":{"rendered":"Monitor your MySQL servers as done before, for free!"},"content":{"rendered":"

With genuine respect to other products<\/a>, the people making those products and the efforts involved, I would like to make an issue:<\/p>\n

Some things have been done before<\/a>, done pretty well (if I may say so), and for free.<\/p>\n

mycheckpoint<\/a> is a free monitoring tool for MySQL. It uses an unorthodox approach of monitoring your MySQL servers by storing the monitored data in SQL format (actually, within a MySQL server). This allows you to either use the fancy JavaScript charting<\/a> (by running mycheckpoint<\/em> as HTTP server<\/a>), or Do-It-Yourself diagnostics<\/a>.<\/p>\n

It allows for a great many more things, among which are custom queries and charts<\/a>: you may add your own queries, to be included in the monitoring scheme. Query your AUTO_INCREMENT<\/strong> values to detect growth rate, query your INFORMATION_SCHEMA<\/strong> tables (if you dare) to learn about your data dimensions, query for query response time to detect performance issues with your website\/database, or query your data itself (e.g. sales per day<\/em>) to get insight about your product. Here are sample charts<\/a> to illustrate.<\/p>\n

Adding a custom query is as easy as producing an INSERT<\/strong> command. And of course you can set up alert conditions<\/a>. You can set them up on your normal monitored data (e.g. seconds behind master<\/em>) or on your custom monitored data (e.g. time it takes to execute cart-items query is too long<\/em>, rate of purchases is below some threshold<\/em> etc.). It works the same since all monitored data, standard & custom, is stored in SQL format: rows, columns, a table.<\/p>\n

This also means you can retroactively check for different thresholds; you can query your data anyway you like! mycheckpoint provides you with a good visualization tool, but, like a good command like client, leaves the data intact for you to analyze the way you like it.<\/p>\n

Of course you can get emailed<\/a> once an alert pops up. But wait, not so fast: you can ask the alert to pop up only if the threshold is trespassed for a given amount of time<\/em>. For example, it may be OK for OS load average to increase for a few moments, but you may wish to be alerted if this happens for over 30<\/strong> minutes continuously.<\/p>\n

The thing is, you get all these in an uncompressed 222K<\/strong> single python script (43K<\/strong> compressed), and there’s no trial period. mycheckpoint<\/em> is completely free to download and use<\/a> under the BSD<\/strong> license. It is listed in 10 essential MySQL tools for admin<\/a>, and is well documented<\/a>.<\/p>\n

I’m not suggesting the scope of mycheckpoint<\/em> levels with that of other products. It is lightweight; it does not have the full featured web interface as others do; there’s work to be done. It only provides basic OS monitoring, and there are missing parts, like replication topology monitoring. But it is feature rich. As the author of mycheckpoint<\/em> I take notice of using it on production for my own servers. It gets the job done.<\/p>\n

It uses some ideas based on existing tools, and a few original ones. Before you say “like never before”<\/em>, take a look at mycheckpoint<\/em>.<\/p>\n","protected":false},"excerpt":{"rendered":"

With genuine respect to other products, the people making those products and the efforts involved, I would like to make an issue: Some things have been done before, done pretty well (if I may say so), and for free. mycheckpoint is a free monitoring tool for MySQL. It uses an unorthodox approach of monitoring your […]<\/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":[],"class_list":["post-4568","post","type-post","status-publish","format-standard","hentry","category-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2bZZp-1bG","_links":{"self":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/4568","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=4568"}],"version-history":[{"count":6,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/4568\/revisions"}],"predecessor-version":[{"id":4575,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/4568\/revisions\/4575"}],"wp:attachment":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/media?parent=4568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/categories?post=4568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/tags?post=4568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}