InnoDB plugin row format performance
Here is a quick comparison of the new InnoDB plugin performance between different compression, row formats that is introduced recently. The table is a pretty simple one:
1 2 3 4 5 6 7 8 9 10 |
<span class="kwrd">CREATE</span> <span class="kwrd">TABLE</span> `sbtest` ( `id` <span class="kwrd">int</span>(10) unsigned <span class="kwrd">NOT</span> <span class="kwrd">NULL</span>, `k` <span class="kwrd">int</span>(10) unsigned <span class="kwrd">NOT</span> <span class="kwrd">NULL</span> <span class="kwrd">DEFAULT</span> <span class="str">'0'</span>, `c` <span class="kwrd">char</span>(120) <span class="kwrd">NOT</span> <span class="kwrd">NULL</span> <span class="kwrd">DEFAULT</span> <span class="str">''</span>, `<span class="kwrd">pad</span>` <span class="kwrd">char</span>(60) <span class="kwrd">NOT</span> <span class="kwrd">NULL</span> <span class="kwrd">DEFAULT</span> <span class="str">''</span>, <span class="kwrd">PRIMARY</span> <span class="kwrd">KEY</span> (`id`), <span class="kwrd">KEY</span> `k` (`k`) ) ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8; |
The table[…]