Re: Server completely locked up on ALTER TABLE statement
Hi,
Beat Vontobel wrote:
...
> The manual says on myisam_max_sort_file_size:
> "Don't use the fast sort index method to create an
> index if the temporary file would become larger
> than this." What's meant by temporary file? MYI or
> MYI+MYD?
The temporary file consists of all index records of _one_ index.
The manual does also say: "myisam_max_sort_file_size: The maximum size of the temporary file that MySQL is allowed to use while re-creating a MyISAM index (during REPAIR TABLE, ALTER TABLE, or LOAD DATA INFILE). If the file size would be larger than this value, the index is created using the key cache instead, which is slower." (http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html)
So MySQL decides itself if it can use a sort file. I found it in the code. So the paragraph you quoted sounds misleading. I asked the docs team to fix it.
Regards
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
4114
April 10, 2006 07:17AM
2184
April 11, 2006 01:13AM
4643
April 11, 2006 08:50AM
2369
April 11, 2006 10:42AM
Re: Server completely locked up on ALTER TABLE statement
2245
April 12, 2006 03:08AM
2239
April 12, 2006 03:19AM
2239
April 12, 2006 02:24AM
2379
April 12, 2006 02:33AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.