…the new SpecJAppServer Results More information from Tom Daly can be found here These results are quite interesting for me as I worked on some of the…how much this was really investigated. Indeed this is much smaller than default. If you have queries which only do small sorts…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…results in much less fragmented indexes because records are inserted in the correct order into sequentially allocated pages after merge-sorting…case of the previous one: mysql> SET expand_fast_index_creation=OFF; Query…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…queries, but that’s often justified by a large reduction in table size. I sort of stumbled upon this idea one day. I…the work on a slave, then piping the results back up to the master with LOAD DATA INFILE, which kind of…
