Timeline for MySQL performance of applying unique constraint single column vs combination column
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 20, 2015 at 15:02 | comment | added | eroomydna | Andy, did you suggest pt-online-schema-change? If the index can be added with this tool you wont lock the table. | |
| Jan 20, 2015 at 14:43 | vote | accept | acnghm | ||
| Jan 20, 2015 at 14:43 | comment | added | acnghm | Thanks. Turns out the DBAs won't index the table as it's too big (85gb) so would lock for hours. However, your comments are helpful and informative. | |
| Jan 15, 2015 at 12:07 | history | answered | eroomydna | CC BY-SA 3.0 |