|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
From: Martijn Tonies (m.tonies
upscene.com)
Date: Thu Jun 05 2008 - 03:03:33 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]