| 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? | mos | 12 Jan |
| • Re: Why does changing a table property rebuild the table? | Dan Nelson | 12 Jan |
| • Re: Why does changing a table property rebuild the table? | mos | 12 Jan |
| • Re: Why does changing a table property rebuild the table? | Dan Nelson | 12 Jan |
| • Re: Why does changing a table property rebuild the table? | Baron Schwartz | 13 Jan |
| • Re: Why does changing a table property rebuild the table? | mos | 14 Jan |
