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

extend mdl_info plugin

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • Plugins
    • 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

          Activity

            People

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

              Dates

                Created:
                Updated:

                Git Integration

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