Mysql alter table GH-OSh is more stable than pt-online-schema-change, but there are some problems in the use process:

  1. 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).
  2. 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!