I’m travelling to Melbourne in a few weeks, to teach another edition of some Open Query course days. Three days this time: Optimisation by Design Storage Engine Optimisation Replication Workshop There are still some seats available; you can sign up for individual days, and there’s very special pricing available for students! The Melbourne dates are [...]
Interesting Google tech talk: Supporting Scalable Online Statistical Processing. Goes for an hour and has a slowish start but around the 10 minute mark the beef starts… basically, rather than doing complete aggregates, he uses statistical sampling to provide a reasonable estimate (unbiased guess) of the result. This makes sense, statistically! It might be possible [...]
This question often comes up, and the general answer given appears to be “CREATE TABLE … SELECT …” But actually, that does not do what you might expect, as this statement creates a table structure based on the resultset of the select, so the column types may differ from your original table, and the table [...]
There’s been talk of a community conf, not to compete with but augmenting the Sun/MySQL one. A Google Group was created to discuss the possility of such an event, its potential, dates/location, and get it going! It’s a public group, please blog & tell others about it! Sheeri suggested OurSQL, like her podcast. Here’s the [...]
During the conf, Keith Murphy spent long late-night hours getting issue 4 of MySQL Magazine ready. Horay to Keith for starting (and continuing) that initiative! (I snapped this pic of Keith + Monty at the MySQL Community dinner)
With assistance from Antony Curtis who spent some coding time with me at the conf, and a number of helpful other individuals (Monty, Sergei, Timour, Igor, patg, Stewart, Brian, Mark, Paul, and others) who answered questions and looked things up, the earlier backend demo can now be executed from a MySQL 5.1 server with the [...]
(I really can’t be stuffed referring to the “mysql conf and expo”, to me it’s the mysql conf). Jay, thanks for a great conference! It was good “being back” and catching up with so many friendly community faces, and all my ex-colleagues among them. My own photos from the event are here: http://www.flickr.com/photos/arjen-lentz/tags/mysqlconf08/, all tagged [...]
While at the MySQL Conf, I bought an Apple Time Capsule (1TB). I like it. It does appear that at least an initial time Machine backup eats significant swap space; not RAM as such, I have 4GB in my MacBook and it’s not used up at all… Anyway, OS X cleans up the (encrypted) swap [...]
Mark started by making the point that when he talks about problems with InnoDB, he’s referring to what he calls “blemishes on a beautiful work of art”. In an earlier direct chat with him he explained that the InnoDB source code is well structured and documented. People active on InnoDB are at Oracle/InnoDB (of course), [...]
The good: male restroom has a baby changetable! The bad: Arjen takes photo in a restroom The ugly: My dear Americans, a koala is not a bear. (This in contrast to the dropbear, which is natively Australian.)