Thanks for the info, i had read this doc. Just wanted to confirm.
So based on doc, sort_buffer_size is also used by myisam tables using group
by or order by in their select statement, does it help in creating indexes
also for myisam tables.
On 6/5/08, Martijn Tonies <m.tonies@stripped> wrote:
> > 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!
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1