All Questions
Tagged with alter-table percona-tools
3 questions
2
votes
1
answer
2k
views
Problem with aborted PT-online-schema change command
I aborted a pt-online-schema change command to change a table definition. Now, when I run pt-online-schema change again, I get this error:
The table <db name>.<table name> has triggers. ...
- 163
4
votes
2
answers
2k
views
How pt-online-schema-change ensures consistency during data copy
I have read pt-online-schema-change documentation and understood that it works by creating triggers and copying data in chunks with in chunk-time seconds(0.5 seconds in default)
Let us consider this ...
- 814
1
vote
0
answers
146
views
pt-online-schema-change with circular replication
So I have an alter table (adding 4 columns) to do on a fairly large table (74 million rows). The problem is this table has firstly to remain online and writable during the whole operation and ...
- 11