running out of INTs?
-
-
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Before you do anything, take a backup.
- End of conversation
New conversation -
-
-
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
I've rebuilt hot, tens of GB tables with https://www.percona.com/doc/percona-toolkit/LATEST/pt-online-schema-change.html … before.
-
@njvack pleased to hear you're making good use of pt-online-schema-change :)
End of conversation
New conversation -
-
-
Depends, do you need to preserve the data?
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
You're using innodb-file-per-table, right? And you have enough local disk free to make a copy of the tags table (I don't think you can avoid a table copy)? I'd probably head for percona's pt-online-schema-change tool...
-
Thank you! I think I will end up doing this more directly (copy table manually and alter on that) but the percona tools are ones I love very much
- Show replies
New conversation -
-
-
I'd create a new table and select insert the data from the old table into it. It'll take a while. Someone else might know a better way.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.