Not the answer you need?
Register and ask your own question!

Adverse effects of specifying --no-checkplan for pt-online-schema-change?

dw_rchaudw_rchau EntrantInactive User Role Beginner
Hi there,

I've recently run into a situation where I could not perform online alter table operations to modify the type of one column from tinyint(3) unsigned to int(10) unsigned using the pt-online-schema-change without specifying --nocheck-plan since the table has a multi-column primary key. I believe that there should be no problem with this operation, but I am a bit wary of specifying --nocheck-plan in a production environment since the docs do not make it clear what sort of risks are involved.

Could somebody inform me what risks I face by specifying --no-checkplan when using the pt-online-schema-change tool? Specifically, I want to know if there is any potential risk of data loss.

Thanks a bunch,
Ryan

Comments

  • dw_rchaudw_rchau Entrant Inactive User Role Beginner
    Update: Since I've yet to receive any confirmation either way, I'm going to go the conservative route and assume that there could be potential data loss if --no-checkplan is specified until informed otherwise.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.