List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:June 5 2008 8:43am
Subject:Re: sort_buffer_size
View as plain text  
Hi Marti,
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:
> 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:
> 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
> My thoughts:
> Database development questions? Check the forum!
> --
> MySQL General Mailing List
> For list archives:
> To unsubscribe:

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