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, […]
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: […]
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 […]
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 […]
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', […]