Run pt-online-schema-change with multiple ALTER queries synchronously
1
vote
1
answer
998
views
I want to run 3 ALTER queries with pt-online-schema-change tool:
--alter "ADD INDEX userid_sid_ts_fid (user_id, scorecard_id, timestamp, factor_id), DROP INDEX uidts, RENAME INDEX userid_sid_ts_fid to uidts"
However I face this error:
Error altering new table
*****
._scoring_basis_new
: DBD::mysql::db do failed: Key 'userid_sid_ts_fid' doesn't exist in table '_scoring_basis_new'
So it looks like is trying to run these 3 queries asynchronously rather than 1 by 1. How can I prevent that?
Asked by Diego
(113 rep)
Dec 15, 2022, 12:30 PM
Last activity: Dec 15, 2022, 04:11 PM
Last activity: Dec 15, 2022, 04:11 PM