Hi!
>>>>> "Nick" == Nick Arnett <[EMAIL PROTECTED]> writes: Nick> I haven't been able to dig up any specific information about how to get Nick> maximum performance when making changes to large tables. I have a table Nick> that's close to 4 GB, which I'm altering to come up with the best trade-off Nick> between performance and speed. Dropping a column or an index seems Nick> exceedingly slow and I'm wondering what parameters matter for this. I'm Nick> already using the highest-performance drive I can lay my hands on. What Nick> else matters? MySQL currently almost always recreates the full index and data tables when you do an alter table (to be fixed in 4.1). To speed this up for MyISAM tables, you can set up the myisam_sort_buffer_size to a much larger value. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
