Making full table scan 10x faster in InnoDB

At MySQL Connect 2013, I talked about how we used MySQL 5.6 at Facebook, and explained some of new features we added to our Facebook MySQL 5.6 source tree. In this post, I'm going to talk about how we made full table scan faster in InnoDB. Faster full table scan in InnoDB In general, almost all queries from applications are using indexes, and reading very few rows (0..1 on primary key lookups and

[sh2]

We take logical backups by mysqldump at Facebook. そうなんだ / 本体に入る可能性があるとしたらMulti Range Readの機能追加として、かなあ http://enterprisezine.jp/dbonline/detail/3606?p=2

[ya--mada]

あっちっち

[sedh]

FacebookのMySQL5.6のfull table scanの高速化に関する記事

[tmatsuu]

おー。mysqldumpなのね。 / “Yoshinori Matsunobu's blog: Making full table scan 10x faster in InnoDB”

[yoppiblog]

おお!

[taka222]

”Yoshinori Matsunobu's blog: Making full table scan 10x faster in InnoDB”

[elf]

アツい！！ #mysql #facebook #matsunobu

[kazeburo]

mysqldump使ってるんだ / “Yoshinori Matsunobu's blog: Making full table scan 10x faster in InnoDB”

[riywo]

cool