Hi everyone,
I have a question regarding the toolkit ‘pt-online-schema-change’ (percona-toolkit-3.0.5-1.el6.x86_64).
We are using this toolkit for OPTIMIZE tables of our production databases (MySQL 5.5.42). Until now it is working well except name of constraints (foreign keys). Always when this tool execute a MySQL table, it renames (add or remove an underscore in front of FK name) all foreign keys on this table. I know that this is done because of MySQL restriction to not allow two foreign keys with the same name. But does it have this toolkit (pt-online-schema-change’) any parametrization that will rename again the foreign keys in previous name like before executing the toolkit (like rename of tables: _tablename_new → tablename)?
Execution of this tool is done like below:
pt-online-schema-change -h ${MYSQL_HOST} -u ${MYSQL_USER} -p${MYSQL_PASSWORD} --execute --print --alter “ENGINE=InnoDB” --alter-foreign-keys-method=rebuild_constraints D=${DATABASE_NAME},t=$table
If anyone can support us in this question, I will appreciate.
Thanks,
Shkemb