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.

regards
anandkl


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:
> 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
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

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