Yesterday I attended the SQL Server Data Services – Software Design Review event in the Microsoft mountain view campus. Thanks for Ryan Dunn who accepted my invitation to attend this[…]
Monthly Archive: April 2008
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[…]
Windows Live Writer, best blogging tool
Windows Live Writer is of the best blogging tool that I found in recent times. The tool is very convenient to write and it provides all possible options that one[…]