MySQL’s design team triumphs again!
Posted on August 24th, 2009 by whinger. Filed under Tech, Web Development, Whinges.
From this upgrade note for MySQL 5.1
As of MySQL 5.1.15, InnoDB rolls back only the last statement on a transaction timeout.
Oh, what a fantastic design decision.
I love that there’s no explanation, no reasoning. Just “we’ve fucked over transactions”.
It’s almost like they decided that MySQL was getting far too close to being a usable enterprise solution so they did this to make sure it stayed where they know it really should be – website backend city.
Edit: MAD points out that the old behaviour can be turned back on with an option, but most people new to a database will install it with the default options and really, implementing this option at all just displays complete disregard for the ACID ideals