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
4101
April 10, 2006 07:17AM
2176
April 11, 2006 01:13AM
4639
April 11, 2006 08:50AM
2362
April 11, 2006 10:42AM
2239
April 12, 2006 03:08AM
Re: Server completely locked up on ALTER TABLE statement
2232
April 12, 2006 03:19AM
2230
April 12, 2006 02:24AM
2366
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.