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

Add new thread states for certain WSREP scenarios

    XMLWordPrintable

    Details

      Description

      Certain thread states can have very different meanings in a Galera Cluster environment. For example:

      • checking permissions - For DDL, this often means that the thread is waiting for some other transaction(s) to finish, so that the DDL can be executed in isolation (when wsrep_OSU_method=TOI).
      • statistics - I believe that this can mean that the thread is waiting, either because flow control is in effect or because DDL is being executed in isolation (when wsrep_OSU_method=TOI).
      • query end - I believe that this usually means that either that flow control is in effect, so the query can't be certified yet, or that the query's writeset is being certified by the other nodes, but it hasn't finished yet.

      Thread states might be overloaded in other cases too, but these are the ones that I see most often.

      Maybe we need some new thread states, such as the following?:

      • waiting to execute in isolation - DDL is waiting to execute in TOI mode.
      • waiting for TOI DDL - some other statement is waiting for DDL to complete.
      • waiting for flow control - some statement is paused while flow control is in effect.
      • waiting for certification - the transaction is being certified.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              4 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration