• MySQL monitoring: storing, not caching

    February 22, 2012

    I've followed with interest on Baron's Why don’t our new Nagios plugins use caching? and Sheeri's Caching for Monitoring: Timing is Everything. I wish to present my take on this, from mycheckpoint's point of view. So mycheckpoint works in a completely different way. On one hand, it doesn't bother with caching. On the other hand, […]

  • Call for Nominations for 2012 MySQL Community Awards

    February 13, 2012

    This post complements Henrik's Call for Nominations for 2012 MySQL Community Awards. Recap: we keep the tradition of awarding MySQL community members for their notable contributions to the MySQL ecosystem. Previously, the awards were given by MySQL AB/Sun. Later on they were given by the community itself, as will follow this year, when the awards […]

  • MySQL/QueryScript use case: DELETE all but top N records per group

    February 9, 2012

    Some administrative tasks can be simplified by using common_schema/QueryScript. I'm collecting a bunch of these for documentation. Here's one for example: The DBA/developer has the task of retaining only top 3 most populated countries per continent. That is, she has to DELETE 4th, 5th, 6th, ... most populated counties in each continent. Is it possible […]

  • common_schema rev. 218: QueryScript, throttling, processes, documentation

    February 8, 2012

    common_schema, revision 218 is released, with major new features, top one being server side scripting. Here are the highlights: QueryScript: server side scripting is now supported by common_schema, which acts as an interpreter for QueryScript code. Throttling for queries is now made available via the throttle() function. Enhancements to processlist-related views, including the new slave_hosts […]

  • QueryScript: SQL scripting language

    February 8, 2012

    Introducing QueryScript: a programming language aimed for SQL scripting, seamlessly combining scripting power such as flow control & variables with standard SQL statements or RDBMS-specific commands. QueryScript is available fro MySQL via common_schema, which adds MySQL-specific usage. What does QueryScript look like? Here are a few code samples: Turn a bulk DELETE operation into smaller […]

  • MySQL command line vs. visual editors - reflections

    February 1, 2012

    My previous post drew some attention, and in particular two comments I wish to relate to. I also wish to make a more fine-grained observation on visual editors. One comment is by Peter Laursen, who rejected the generalization in my post, and another by wlad, who was harsher (but to the point), suggesting my post […]

Powered by Wordpress and MySQL. Theme by openark.org