Fun MySQL fact of the day: the IO thread

On Friday, we looked at a pretty fun and very handy use of the MySQL binary log to perform point-in-time recovery during a make-believe disaster. We're going to circle back to point-in-time recovery a bit later this week, but I want to first start looking at MySQL's replication implementation. ... read more

Fun MySQL fact of the day: mysqlbinlog

It's 3:37 A.M. when your phone blares out. Your hands are numbed from the early on-set of carpel tunnel and you can't hush the wailing siren that has become of your phone. With adrenaline coursing through your body, you shove your phone under your pillow mashing around in the dark ... read more

Fun MySQL fact of the day: table pullouts

As noted yesterday, MySQL 5.6 was released with a large number of optimisations to the subquery engine. In particular, a number of changes were made to optimise for non-scalar, uncorrelated subqueries, allowing them to be run as... you guess it! Joins. ... read more

Fun MySQL fact of the day: subqueries in MySQL5.5

The year 2013 can be remembered by 3 separate things: Justin Timberlake, the series finale of Breaking Bad, and the release of MySQL 5.6. Though, if you aren't a MySQL historian, the release of MySQL 5.6 may have passed you by and you may have missed the significance as it ... read more
1 2 3 4 5 6