Colin Charles Agenda

If you haven’t already signed up to attend the MySQL Conference & Expo 2008, you know you’re clearly missing out. Most tutorials in the conference have sold out, so I suggest getting to it as soon as possible. Remember, that all speakers have access to a 20% discount code, so email me if you’d like one.

Igor Babaev, is speaking on Wednesday, 16/04/2008, at 2pm, on Batched Key Access: a Significant Speed-up for Join Queries. To whet your appetite, there are also Batched Key Access Software Previews available now!

So what is Batched Key Access (BKA)? Its a new advanced technique to execute queries with multi-way join operations. The idea behind it is to accumulate several keys in a buffer, then only access the joined table, possibly changing the order of lookups, to optimise the sequence of disk seeks. Used with the NDB Cluster storage engine, it helps minimise the number of round-trips between the server and cluster nodes.

If you’re after the nitty-gritty technical details behind the BKA Join, look no further than reading WL#2771. If you’d like to try it out, there are binaries for Solaris, Linux and Windows available at the software previews page. If you need to know more, don’t miss Igor’s talk next Wednesday, on the 16/04/2008 at the MySQL Conference & Expo 2008!

Technorati Tags: mysql, mysqluc, mysqluc2008, mysqluc08, santa clara, mysql conference & expo, batched key access, bka, igor babaev, bka join, join, software previews, bka previews

MySQL has till the 18th to review all the student applications we’ve had for the Google Summer of Code 2008.

We’ve had 48 applications (it was 49 before one withdrew), up from the 35 that we had last year - growth! Currently, we also have 3 non-MySQL’ers being mentors (this is expected to grow), and we’ve also invited the phpMyAdmin team to mentor folk with their projects in mind, as its a very popular web-based UI.

What really is interesting is that out of the 48 applications, 13 already have owners wanting them! That’s 13 mentors, ready to go with the early applicants, and this can only mean good news (i.e. more to come).

Let’s hope that Google provides us more than our previous 10 slots, as in the early stages, we already have a 27% approval rating of students and their projects. Interesting times ahead.

Technorati Tags: gsoc, gsoc2008, mysql, google, summer of code

Today I tried to register for LugRadio Live USA 2008, seeing that I will be in San Franciso this Friday. Apparently, their payment provider doesn’t like my IP address (or ISP).

Declined: We do not currently process transcations from the country your Internet Service Provider is located in.

Yes, I could login to a foreign VPN (servers in Sweden for my employer), or I could tunnel via SSH and use a SOCKS proxy to the various machines I have access to around the world. But I think that’s just too much effort, for silly Nochex. Welcome to the globalised 21st century.

Instead I’ve emailed Jono Bacon. I hope that suffices as a pre-registration. I can fork out the ten bucks in cash ;)

Technorati Tags: nochex, silly, ISP, ip, transactions, lugradio, lugradio live usa, ecommerce