MySQL Performance Blog 禄 How fast can you sort data with MySQL _ - The Diigo Meta page

• 09 Dec 09
  

  Alexey Gusev

  webdev mysql optimization

• 25 Aug 09
  

  anonymous anonymous

  SET sort_buffer_size=100000;

  mysql

• 05 Mar 09
  

  database mysql performance tuning optimization

• 26 May 08
  

  Navneet Kumar

  file sorting

  MySQL Tuning Performance

• 21 Aug 07
  

  mohakevin

  Explican como funciona la ordenacion en mysql, como optimizarla y que no siempre dar más cantidad de sort_buffer tendria que ser mejor

  mysql optimization sysadmin Performance database

• 

  Jean-Marc Fontaine

  mysql optimisation tri

• 18 Aug 07
  

  Ken Wei

  mysql sort sort_buffer_size

  • What do we learn from these results:

     
     
    • Benchmark your application Unfortunately general tuning guidelines can be wrong for your particular case, or generally wrong because they tend to reprint the manual which is often written based on theoretical expectations rather than supported by large amount of testing.
     
    • sort_merge_passes are not that bad. Setting your sort_buffer_size large enough so there is zero sort_merge_passes may not be optimal. 
    • World is full of surprises I obviously did not expect to get such results, and this is not any exception. Even spending a lot of time optimizing and otherwise working with MySQL I continue to run in results which surprise me. Some are later expected others come from underlying bugs and later fixed.

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.