List:General Discussion« Previous MessageNext Message »
From:mos Date:January 12 2009 5:10pm
Subject:Why does changing a table property rebuild the table?
View as plain text  
I'm using MySQL 5.1 and if I execute:

alter table mytable delay_key_write=1;

it takes about an hour to rebuild the table. Why? As far as I know it is 
not changing the table structure. So why does it have to make a copy of the 
table and reload all the data?

TIA
Mike

Thread
Why does changing a table property rebuild the table?mos12 Jan
  • Re: Why does changing a table property rebuild the table?Dan Nelson12 Jan
    • Re: Why does changing a table property rebuild the table?mos12 Jan
      • Re: Why does changing a table property rebuild the table?Dan Nelson12 Jan
        • Re: Why does changing a table property rebuild the table?Baron Schwartz13 Jan
          • Re: Why does changing a table property rebuild the table?mos14 Jan