{"id":768,"date":"2008-04-09T03:46:32","date_gmt":"2008-04-09T08:46:32","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/09\/batched-key-access-join-previews-available"},"modified":"2008-04-09T03:47:42","modified_gmt":"2008-04-09T08:47:42","slug":"batched-key-access-join-previews-available","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/09\/batched-key-access-join-previews-available","title":{"rendered":"Batched Key Access Join Previews available"},"content":{"rendered":"<p><em>If you haven&#8217;t already signed up to attend the <a href=\"http:\/\/www.mysqlconf.com\/\">MySQL Conference &#038; Expo 2008<\/a>, you know you&#8217;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&#8217;d like one.<\/em><\/p>\n<p>Igor Babaev, is speaking on Wednesday, 16\/04\/2008, at 2pm, on <a href=\"http:\/\/en.oreilly.com\/mysql2008\/public\/schedule\/detail\/582\">Batched Key Access: a Significant Speed-up for Join Queries<\/a>. To whet your appetite, there are also <a href=\"http:\/\/forge.mysql.com\/wiki\/Batched_Key_Access\">Batched Key Access Software Previews available now<\/a>!<\/p>\n<p>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.<\/p>\n<p>If you&#8217;re after the nitty-gritty technical details behind the BKA Join, look no further than reading <a href=\"http:\/\/forge.mysql.com\/worklog\/task.php?id=2771\">WL#2771<\/a>. If you&#8217;d like to try it out, there are binaries for Solaris, Linux and Windows available at the <a href=\"http:\/\/downloads.mysql.com\/forge\/bka_preview\/\">software previews <\/a>page. If you need to know more, don&#8217;t miss <a href=\"http:\/\/en.oreilly.com\/mysql2008\/public\/schedule\/detail\/582\">Igor&#8217;s talk<\/a> next Wednesday, on the 16\/04\/2008 at the <a href=\"http:\/\/www.mysqlconf.com\/\">MySQL Conference &#038; Expo 2008<\/a>!<\/p>\n<p>Technorati Tags: <a class=\"performancingtags\" rel=\"tag\" href=\"http:\/\/technorati.com\/tag\/mysql\">mysql<\/a>, <a class=\"performancingtags\" rel=\"tag\" href=\"http:\/\/technorati.com\/tag\/mysqluc\">mysqluc<\/a>, <a class=\"performancingtags\" rel=\"tag\" href=\"http:\/\/technorati.com\/tag\/mysqluc2008\">mysqluc2008<\/a>, <a class=\"performancingtags\" rel=\"tag\" href=\"http:\/\/technorati.com\/tag\/mysqluc08\">mysqluc08<\/a>, <a class=\"performancingtags\" rel=\"tag\" href=\"http:\/\/technorati.com\/tag\/santa%20clara\">santa clara<\/a>, <a class=\"performancingtags\" rel=\"tag\" href=\"http:\/\/technorati.com\/tag\/mysql%20conference%20&amp;%20expo\">mysql conference &amp; expo<\/a>, <a class=\"performancingtags\" rel=\"tag\" href=\"http:\/\/technorati.com\/tag\/batched%20key%20access\">batched key access<\/a>, <a class=\"performancingtags\" rel=\"tag\" href=\"http:\/\/technorati.com\/tag\/bka\">bka<\/a>, <a class=\"performancingtags\" rel=\"tag\" href=\"http:\/\/technorati.com\/tag\/igor%20babaev\">igor babaev<\/a>, <a class=\"performancingtags\" rel=\"tag\" href=\"http:\/\/technorati.com\/tag\/bka%20join\">bka join<\/a>, <a class=\"performancingtags\" rel=\"tag\" href=\"http:\/\/technorati.com\/tag\/join\">join<\/a>, <a class=\"performancingtags\" rel=\"tag\" href=\"http:\/\/technorati.com\/tag\/software%20previews\">software previews<\/a>, <a class=\"performancingtags\" rel=\"tag\" href=\"http:\/\/technorati.com\/tag\/bka%20previews\">bka previews<\/a><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20Batched%20Key%20Access%20Join%20Previews%20available&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2008%2F04%2F09%2Fbatched-key-access-join-previews-available&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"2c05a81f94\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/09\/batched-key-access-join-previews-available?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-768\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/09\/batched-key-access-join-previews-available?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-768\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/09\/batched-key-access-join-previews-available?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-768\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/09\/batched-key-access-join-previews-available?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>If you haven&#8217;t already signed up to attend the MySQL Conference &#038; Expo 2008, you know you&#8217;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&#8217;d like [&hellip;]<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20Batched%20Key%20Access%20Join%20Previews%20available&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2008%2F04%2F09%2Fbatched-key-access-join-previews-available&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"2c05a81f94\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/09\/batched-key-access-join-previews-available?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-768\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/09\/batched-key-access-join-previews-available?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-768\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/09\/batched-key-access-join-previews-available?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-768\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/09\/batched-key-access-join-previews-available?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_options":[]},"categories":[23],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-co","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":2289,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/optimizing-your-innodb-buffer-pool-usage-by-steve-hardy","url_meta":{"origin":768,"position":0},"title":"Optimizing your InnoDB buffer pool usage by Steve Hardy","date":"5\/2\/2012","format":false,"excerpt":"Steve Hardy of Zarafa. Work that has been done to make Zarafa better. Why do you optimise your buffer pool? To decrease your I\/O load. How can you do it? Buy more RAM, page compression, less (smaller) data, rearrange data. MariaDB or Percona Server allows you to inspect your buffer\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2256,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/mariadb-5-3-query-optimizer-by-sergey-petrunia","url_meta":{"origin":768,"position":1},"title":"MariaDB 5.3 query optimizer by Sergey Petrunia","date":"5\/2\/2012","format":false,"excerpt":"Sergey Petrunia of the MariaDB project. What exactly is not working in MySQL? MySQL is poor at decision support\/analytics. With large datasets you need special disk access strategies. Complex queries like insufficient subquery support and big joins are common int he MySQL world. DBT-3 is used, scale=30, with a 75GB\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2247,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/new-mysql-5-6-features-by-oli-sennhauser","url_meta":{"origin":768,"position":2},"title":"New MySQL 5.6 Features by Oli Sennhauser","date":"5\/2\/2012","format":false,"excerpt":"First talk at FOSDEM MySQL Devroom by Oli Sennhauser, of FromDual. Quick notes\/liveblog of the talk, plus links from a quick search. New Release Model: starts with at least in beta quality, milestone releases are RC quality (every 3-6 months), between milestones new features are allowed, GA releases every 12-18\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":706,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/01\/28\/morning-sessions-at-mysql-miniconf","url_meta":{"origin":768,"position":3},"title":"Morning sessions at MySQL MiniConf","date":"28\/1\/2008","format":false,"excerpt":"Upcoming MySQL Features - Stewart SmithStewart's talk on Upcoming MySQL Features was sort of a roadmap of what one might expect to see in MySQL 5.1 and above - he touched on Falcon, online backup, batched key access, Maria, Proxy, Workbench, and some cluster changes. When he shares his slides,\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":564,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2007\/06\/07\/mysql-resources-across-the-interwebs","url_meta":{"origin":768,"position":4},"title":"MySQL Resources across the Interwebs","date":"7\/6\/2007","format":false,"excerpt":"In an effort to reduce the number of open tabs I have in Firefox, I have some rather interesting MySQL-related resources that I think the rest of Planet MySQL will quite enjoy.Linbit (the makers of DRBD) and MySQL are in a partnership now, and Irwan Jamaluddin, a systems adminstrator at\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2286,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/practical-mysql-indexing-guidelines-by-stephane-combaudon","url_meta":{"origin":768,"position":5},"title":"Practical MySQL Indexing guidelines by St\u00c3\u00a9phane Combaudon","date":"5\/2\/2012","format":false,"excerpt":"St\u00e9phane Combaudon of Dailymotion. Index: separate data structure to speed up SELECTs. Think of index in a book. In MySQL, key=index. Consider that indexes are trees. InnoDB's clustered index - data is stored with the Primary Key (PK) so PK lookups are fast. Secondary keys hold the PK values. Designing\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/768"}],"collection":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=768"}],"version-history":[{"count":0,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/768\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=768"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}