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

> 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:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html

myisam_sort_buffer_size:
 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.

sort_buffer_size:
 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
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

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