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

Feature Request - Add innodb data_locks and data_lock_waits, or better, tables

    XMLWordPrintable

Details

    Description

      The data_locks and data_lock_waits performance_schema tables, available in MySQL 8.0, is a bit different from the information_schema innodb_locks and innodb_lock_waits. The main difference is that the performance_schema tables show locks even when nothing is waiting for them. It would be even better to be able to identify individual row locks.
      The usefulness of this type of monitoring is when having complex transactions which might interlock and cause deadlocks. This is often an issue when migrating from other database systems where locking is different than in MariaDB.

      Attachments

        Activity

          People

            Unassigned Unassigned
            karlsson Anders Karlsson
            Votes:
            1 Vote for this issue
            Watchers:
            5 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.