Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
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
Attachments
Issue Links
- relates to
-
MDEV-4704 PROCESSLIST - Query Rank execution order
- Open