Mysql alter table GH-OSh is more stable than pt-online-schema-change, but there are some problems in the use process:
- If gh-OST is used, the delete operation is performed just before the use of gh-Ost, which will directly cause the table ID to be automatically reset (the effect is the same as that of version 8.0 or lower, mysql server is restarted).
- The last step is lost and the process is shut down. The intermediate tables _GHO and _GHC are not deleted
This article is published by OpenWrite!