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

online-schema-change AND READ-UNCOMMITTED

trideouttrideout EntrantInactive User Role Beginner
I am using transaction-isolation = READ-UNCOMMITTED to improve performance on a heavy load read write database but I was wondering if there are any potential issues with using pt-online-schema-change in this mode.

Comments

  • martin.arrietamartin.arrieta Member Inactive User Role Beginner
    There are no *ADDITIONAL* risks on pt-osc if you are using read-uncommitted isolation level.

    If your server have a heavy write/read load, try to avoid to use --alter-foreign-keys-method=drop_swap because the table that you are updating will not exist for a short period of time (between dropping the original table and renaming the temporary table).

    Please read carefully the documentation before run it. ( http://www.percona.com/doc/percona-toolkit/2.1/pt-online-sch ema-change.html)

    Martin.
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.