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

information_schema.innodb_mutexes.name column is not populated

    XMLWordPrintable

    Details

      Description

      Compare the outputs of the following statements:

      C:\Program Files\MariaDB 10.3\bin>mysql -uroot -proot -P3316 test
      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 10
      Server version: 10.3.7-MariaDB-log mariadb.org binary distribution
       
      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [test]> select * from information_schema.innodb_mutexes;
      +------+---------------------+-------------+----------+
      | NAME | CREATE_FILE         | CREATE_LINE | OS_WAITS |
      +------+---------------------+-------------+----------+
      |      | log0log.cc          |         644 |        1 |
      |      | combined buf0buf.cc |        1510 |        1 |
      +------+---------------------+-------------+----------+
      2 rows in set (0.005 sec)
       
      MariaDB [test]> show engine innodb mutex;
      +--------+-----------------------------+---------+
      | Type   | Name                        | Status  |
      +--------+-----------------------------+---------+
      | InnoDB | rwlock: log0log.cc:644      | waits=1 |
      | InnoDB | sum rwlock: buf0buf.cc:1510 | waits=1 |
      +--------+-----------------------------+---------+
      2 rows in set (0.005 sec)
      

      One would expect Name column in the output of the first one to contain a mutex name, as the second one demonstrates (or more specific one). It looks like the name is always missing.

        Attachments

          Activity

            People

            Assignee:
            marko Marko Mäkelä
            Reporter:
            valerii Valerii Kravchuk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: