Recently, while doing a test process to examine resource usage and the time required to alter the table using pt-osc, it leads to a loss of triggers even though the –preserve-triggers option is specified. I made the decision to recreate the identical circumstance so that everyone could see it.
Test environment :
OS: Amazon Linux 2
MySQL version: 5.7.40
pt-online-schema-change version: 3.1.0
Before digging deeper, we must first obtain the whole picture. Here is an illustration of the table’s structure.