Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4619

PLUGINS - Add LOCKS information at I_S (lock table / lock functions / lock events and others locks / get_lock function / mdl locks)

        Details

        • Type: Task
        • Status: Closed
        • Priority: Blocker
        • Resolution: Duplicate
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None

          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?

            Gliffy Diagrams

              Attachments

                Issue Links

                duplicates

                Task - A task that needs to be done. MDEV-296 LOCK INFORMATION

                • Trivial - Cosmetic problem like misspelt words or misaligned text.
                • Closed
                is duplicated by

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

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Closed
                is part of

                Task - A task that needs to be done. MDEV-4704 PROCESSLIST - Query Rank execution order

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Open

                  Activity

                  Hide
                  Permalink
                  rspadim roberto spadim added a comment -

                  please make this a duplicate resolution

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

                  Show
                  rspadim roberto spadim added a comment - please make this a duplicate resolution is duplicated by Task - A task that needs to be done. MDEV-4748 metadata_lock_info plugin

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      rspadim roberto spadim
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: