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

metadata_lock_info plugin

Details

    • Task
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.7
    • None
    • None

    Description

      Kentoku Shiba (author of Spider storage engine) suggests metadata_lock_info plugin:

      This plugin makes it possible knowing "who has metadata locks". In development stage, sometimes DBAs meet metadata locks when using alter table statement. This metadata locks are sometimes caused by GUI tools. In service stage, sometimes DBAs meet metadata locks when using alter table statement. This metadata locks are sometimes caused by long batch processing. In many cases, the DBAs need to judge immediately. So I made it for all DBAs.

      Plugin is available at:
      lp:~kentokushiba/maria/10.0.3-metadata_lock_info

      Attachments

        Issue Links

          duplicates

          Task - A task that needs to be done. MDEV-4619 PLUGINS - Add LOCKS information at I_S (lock table / lock functions / lock events and others locks / get_lock function / mdl locks)

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          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

            Ascending order - Click to sort in descending order
            svoj Sergey Vojtovich created issue -
            rspadim roberto spadim made changes -
            Field Original Value New Value
            rspadim roberto spadim made changes -
            rspadim roberto spadim made changes -
            Attachment metadata_lock_info.cc [ 23300 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0.6 [ 13202 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0.7 [ 14100 ]
            Fix Version/s 10.0.6 [ 13202 ]
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Minor [ 4 ]
            svoj Sergey Vojtovich made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 27808 ] MariaDB v2 [ 45174 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 45174 ] MariaDB v3 [ 65832 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 65832 ] MariaDB v4 [ 132164 ]

            People

              svoj Sergey Vojtovich
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.