Pt-online-schema-change - Exiting due to errors while restoring triggers: DBD::mysql::db do failed: Lock wait timeout exceeded; try restarting transaction

MySQL/InnoDB doesn’t give you the ability to visualize high/low priority statements so there’s nothing that can be done from a user standpoint either. A timeout of 5s does not imply 5s of waiting even if acquired after 0.2s, so I don’t understand why you would need to split high/low statements anyways.

2 Likes