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

pt-online-schema-change to change the collation of a large table?

italiano40italiano40 EntrantInactive User Role Beginner
How can I structure this call?


  • mirfanmirfan Database Administrator Inactive User Role Beginner
    I think general character set and collation is latin1 and latin1_swedish_ci respectively and if you change the default collation of a table, each column you create in that table will get that collation. Anyway, you can change table collation by using pt-online-schema change tool something like below.

    $ pt-online-schema-change --alter 'convert to character set utf8 collate utf8_unicode_ci' --statistics --execute h=server,D=db_name,t=table_to_alter,u=dbuser

    This will update the table character set to utf8 and collation to utf8_unicode_ci for target table.
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.