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

PROCESSLIST - Query Rank execution order

        Details

        • Type: Task
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None

          Description

          hi guys, based on MDEV-4672 / MDEV-4748
          could we see when a query will be executed?
          (i think in mdl.h this is called as wait-for graph? or maybe it's the "A pending metadata lock request."?)

          something like:
          show query order <query id>
          it will return:

          message query id
          waiting unlock table 1
          waiting alter table 2
          waiting xxxxxx 999999

          this is nice when we have a busy server and want know when a query will be executed (or not), and help DBA to kill it or not

          —
          we could put another column to see informations about a lock
          in MDEV-4619 we have a lock table in information schema, maybe this could be used here to link to that table, example:

          message locks query id
          waiting table lock 1,2,3,4,5 1234
          waiting lock tables 44 423
          waiting update 66 44

            Gliffy Diagrams

              Attachments

                Issue Links

                includes

                Task - A task that needs to be done. MDEV-4672 PROCESSLIST - add two columns about query type and tables

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

                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-6864 extend mdl_info plugin

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

                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

                  Activity

                  There are no comments yet on this issue.

                    People

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

                      Dates

                      • Created:
                        Updated: