• DELETE, don't INSERT

    June 27, 2012

    Have just read INSERT, Don’t DELETE by Aaron Brown, and have some lengthy response, which is why I write this post instead of commenting on said post. I wish to offer my counter thought and suggest that DELETEs are probably the better choice. Aaron suggests that, when one wishes to purge rows from some table, […]

  • A new MySQL backups temperature scale, with showers

    June 26, 2012

    We're used to Cold, Warm and Hot backups. This scale of three temperatures does not quite reflect the impact of backups on your MySQL database. In this post I offer a new backup temperature scale, and (somewhat seriously) compare it with showers. Call it the backup shower scale. A database backup is like a shower: […]

  • Who is hogging my MySQL connections?

    June 21, 2012

    Got "too many connections" this morning. New attempts continuously abort. Every once in a while some slipped through, but overall behavior was unacceptable. max_connections is set to 500, well above normal requirements. Immediate move: raise max_connections to 600, some urgent connections must take place. But, this is no solution: if 500 got hogged, so will […]

  • On stored routines and dynamic statements

    June 18, 2012

    I very much enjoyed reading Overloading Procedures by Michael McLaughlin: good stuff! I'm dealing with similar issues in common_schema/QueryScript, where I implement a whole new scripting language within MySQL, interpreted by stored routines. I am now finalizing the next version of common_schema/QueryScript, with a major addition to the scripting language to put yet even more […]

  • CHAR and spaces

    June 12, 2012

    I know about it, I knew about it all along, but... it's so easy to fall for it; there's just so much absurdity! A CHAR type has a known number of characters. For example, the column: CountryCode CHAR(3) CHARSET ascii NOT NULL - is known to have exactly three characters. These could be 'USA', 'FRA', […]

 
Powered by Wordpress and MySQL. Theme by openark.org