Archive for the ‘Uncategorized’ Category

Phew, here we go, this blog post has been long time coming! A few months ago I started toying around with the idea of analyzing the PlanetMySQL public blog feed. It doesn’t take long to extract the data and prepare it for analysis but between lots of work and procrastination this blog post was left [...]

Prepared statements and code re-use

Posted: 21st December 2010 by Darren Cassar in Uncategorized

An SQL error which was a pain to get to the root of: ERROR 1444 (HY000): The prepared statement contains a stored routine call that refers to that same statement. It’s not allowed to execute a prepared statement in such a recursive manner Whist coding mysql reverse reconciliation for Securich (the Security plugin for MySQL) [...]

State of the MySQL Community

Posted: 10th November 2010 by Darren Cassar in Uncategorized

A very interesting presentation by Kaj Arnö about the State of the MySQL Community. The initial part of the presentation is about the history of how things happened with MySQL, Sun and Oracle, then it describes the current state of our community. The final part of the presentation is fairly enough promotion towards SkySQL for [...]

InnoDB & MySQL wrt Oracle model version

Posted: 4th November 2010 by Darren Cassar in Uncategorized

After this mornings twitteriffic panic where people thought Oracle had removed innodb from the mysql community version, its better to clear some things out. As a friend explained, mysql and innodb are free as in free speech and free beer (the dream). Hence Oracle model version is only talking about ENTERPRISE versions of mysql NOT [...]