[MDEV-4619] PLUGINS - Add LOCKS information at I_S (lock table / lock functions / lock events and others locks / get_lock function / mdl locks) Created: 2013-06-05  Updated: 2013-08-29  Resolved: 2013-08-29

Status: Closed
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Blocker
Reporter: roberto spadim Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-296 LOCK INFORMATION Closed
is duplicated by MDEV-4748 metadata_lock_info plugin Closed
PartOf
is part of MDEV-4704 PROCESSLIST - Query Rank execution order Open

 Description   

hi, i need information about locks in tables, and locks of GET_LOCK
how could i get this information via information_schema plugin?
what i need:

table_locks:
database, table, thread (connection), lock type (write/read), lock_create_time

get_locks:
lock_name, locked, thread(connection), lock_duration, lock_create_time

i was reading mariadb 10.0.2 and it use a MDL maybe it's a abstract lock right? there's more usefull information that MDL can expose?

 Comments   
Comment by roberto spadim [ 2013-08-29 ]

please make this a duplicate resolution

is duplicated by
Task - A task that needs to be done.
MDEV-4748 metadata_lock_info plugin

Generated at Thu Feb 08 06:57:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.