Re: Server completely locked up on ALTER TABLE statement
Thanks for the helpful information. So one check I should do is to substantially lower myisam_max_sort_file_size to force the server to use the key cache on this ALTER query and look if the problem goes away. If it does, the problem is probably connected to the fast index creation algorithm with large indexes.
Beat Vontobel
http://www.futhark.ch/mysql
Subject
Views
Written By
Posted
4114
April 10, 2006 07:17AM
2184
April 11, 2006 01:13AM
4642
April 11, 2006 08:50AM
2368
April 11, 2006 10:42AM
2245
April 12, 2006 03:08AM
Re: Server completely locked up on ALTER TABLE statement
2238
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.