List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:June 5 2008 8:03am
Subject:Re: sort_buffer_size
View as plain text  

> Is sort_buffer_size works only for innodb or both myisam and innodb.
> Or should i use myisam_sort_buffer_size for myisam

According to:

 The size of the buffer that is allocated when sorting MyISAM indexes during
a REPAIR TABLE or when creating indexes with CREATE INDEX or ALTER TABLE.

 Each thread that needs to do a sort allocates a buffer of this size.
Increase this value for faster ORDER BY or GROUP BY operations

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!

sort_buffer_sizeAnanda Kumar5 Jun
  • Re: sort_buffer_sizeMartijn Tonies5 Jun
    • Re: sort_buffer_sizeAnanda Kumar5 Jun