Batched Key Access Join Previews available
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!