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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > >
