Better visibility of metadata locks
I was also wondering about the possibility of having a new table in I_S database in the Percona Server, that could show the current metadata locks being held by a transaction, quite similar to INNODB_LOCKS table. This is because currently there is no direct way to find out which transaction is holding the metadata locks that are blocking a DDL and that makes metadata locking difficult to diagnose if there are a lot of sleeping transactions.
MySQL 5.7.3 implements wait/lock/
Blueprint information
- Status:
- Not started
- Approver:
- None
- Priority:
- Not
- Drafter:
- None
- Direction:
- Needs approval
- Assignee:
- None
- Definition:
- New
- Series goal:
- None
- Implementation:
- Unknown
- Milestone target:
- None
- Started by
- Completed by
Related branches
Related bugs
Sprints
Whiteboard
Oracle implementation in 5.7.3: https:/
MariaDB implementation in 10.0.7: https:/