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

Document values of FLAG column in I_S.innodb_sys_tables and I_S.innodb_sys_tablespaces properly

    Details

      Description

      Our KB article, https://mariadb.com/kb/en/library/information-schema-innodb_sys_tables-table/, says the following about the FLAG column:

      "0 (InnoDB system table) or 1 (user table)."

      This is not true, as I can easily see values 0, 33 and 41 also for user tables:

      MariaDB [test2]> select * from information_schema.innodb_sys_tables where name like '%ti%';
      +----------+----------------------------+------+--------+-------+------------+---------------+------------+
      | TABLE_ID | NAME                       | FLAG | N_COLS | SPACE | ROW_FORMAT | ZIP_PAGE_SIZE | SPACE_TYPE |
      +----------+----------------------------+------+--------+-------+------------+---------------+------------+
      |       19 | mysql/gtid_slave_pos       |   33 |      7 |     4 | Dynamic    |             0 | Single     |
      |       18 | mysql/transaction_registry |   33 |      8 |     3 | Dynamic    |             0 | Single     |
      |       21 | test/ti1                   |    0 |      5 |     6 | Redundant  |             0 | Single     |
      |       22 | test/ti2                   |    1 |      5 |     7 | Compact    |             0 | Single     |
      |       23 | test/ti3                   |   33 |      5 |     8 | Dynamic    |             0 | Single     |
      |       24 | test/ti4                   |   41 |      5 |     9 | Compressed |          8192 | Single     |
      |       25 | test/ti5                   |   33 |      5 |    10 | Dynamic    |             0 | Single     |
      |       28 | test2/ti0                  |    1 |      5 |    11 | Compact    |             0 | Single     |
      +----------+----------------------------+------+--------+-------+------------+---------------+------------+
      8 rows in set (0.000 sec)
      

      Upstream manual is a bit more correct in explanation of flags, but also lacks specific values explained.

        Attachments

          Activity

            People

            • Assignee:
              greenman Ian Gilfillan
              Reporter:
              valerii Valerii Kravchuk
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: