GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

online-schema-change AND READ-UNCOMMITTED

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • online-schema-change AND READ-UNCOMMITTED

    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.

  • #2
    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.

    Comment

    Working...
    X