Details
Description
include some informations to metadata_lock_info plugin....
there're two lists of granted and waiting locks, should be nice expose this number at information schema:
( https://github.com/MariaDB/server/blob/10.1/sql/mdl.cc#L448 )
/** List of granted tickets for this lock. */ Ticket_list m_granted; /** Tickets for contexts waiting to acquire a lock. */ Ticket_list m_waiting;
should be nice another table to know what locks we are talking about...
something like:
| thread_id | database | table | key | original_mdl_id | granted |
where original_mdl_id is a primary key between the metadata_lock information schema table and metadata_lock_lists new table
'granted' could be 'waiting','granted'
this allow find what thread is waiting lock or not, and a easier filter to metadata_lock information schema
Gliffy Diagrams
Attachments
Issue Links
- relates to
-
MDEV-4704 PROCESSLIST - Query Rank execution order
-
- Open
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions