Timeline for Mysql Alter Tables took 5 hours to add 1 column
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 26, 2016 at 16:00 | comment | added | jaseUK | This is what I believe was happening but I don't understand why the copy would take 5 hours. I can only think services trying to access this table were halting the process. Although they were only reading now writing. | |
| Oct 26, 2016 at 15:37 | comment | added | Andrew Brennan | Hrm that doesn't sound right, the table would only become inaccessible while copying was occuring. | |
| Oct 26, 2016 at 10:49 | comment | added | jaseUK | During the 5 hours I was unable to access the table does that fit your explanation? | |
| Oct 26, 2016 at 9:04 | history | answered | Andrew Brennan | CC BY-SA 3.0 |