pt-osc-handlehighconcurrentytable
As discussed in percona customer ticket #29432:
- pt-osc does perform 'insert into ... select' statements, which is seen as a bulk insert statement and takes a AUTO-INC lock in autoincrement handling (http://
- there is a depth of 200 in innodb's internal deadlock mechanism (http://
This is causing deadlocks to happen when pt-osc is doing operations on a very write heavy table.
One way to fix this is to have pt-osc fetch the data and perform traditional 'insert into .... values ()',which is not a bulk insert and does not hold the AUTO-INC lock
Blueprint information
- Status:
- Not started
- Approver:
- None
- Priority:
- Undefined
- Drafter:
- None
- Direction:
- Needs approval
- Assignee:
- None
- Definition:
- New
- Series goal:
- None
- Implementation:
-
Unknown
- Milestone target:
- None
- Started by
- Completed by