Sample Header Ad - 728x90

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