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