[MDEV-20802] System tablespace is not listed in information_schema.INNODB_SYS_TABLESPACES - Jira

XML

Word

Printable

The system tablespace is not listed in information_schema.INNODB_SYS_TABLESPACES. For example:

MariaDB [(none)]> SELECT * FROM information_schema.INNODB_SYS_TABLESPACES WHERE SPACE=0\G

Empty set (0.000 sec)

I'm not sure if this omission is intentional, or if it's a bug.

Of course, any tables within the system tablespace are listed in information_schema.INNODB_SYS_TABLES. For example:

MariaDB [(none)]> SELECT * FROM information_schema.INNODB_SYS_TABLES WHERE SPACE=0\G

*************************** 1. row ***************************

     TABLE_ID: 14

         NAME: SYS_DATAFILES

         FLAG: 0

       N_COLS: 5

        SPACE: 0

   ROW_FORMAT: Redundant

ZIP_PAGE_SIZE: 0

   SPACE_TYPE: System

*************************** 2. row ***************************

     TABLE_ID: 11

         NAME: SYS_FOREIGN

         FLAG: 0

       N_COLS: 7

        SPACE: 0

   ROW_FORMAT: Redundant

ZIP_PAGE_SIZE: 0

   SPACE_TYPE: System

*************************** 3. row ***************************

     TABLE_ID: 12

         NAME: SYS_FOREIGN_COLS

         FLAG: 0

       N_COLS: 7

        SPACE: 0

   ROW_FORMAT: Redundant

ZIP_PAGE_SIZE: 0

   SPACE_TYPE: System

*************************** 4. row ***************************

     TABLE_ID: 13

         NAME: SYS_TABLESPACES

         FLAG: 0

       N_COLS: 6

        SPACE: 0

   ROW_FORMAT: Redundant

ZIP_PAGE_SIZE: 0

   SPACE_TYPE: System

*************************** 5. row ***************************

     TABLE_ID: 996

         NAME: SYS_VIRTUAL

         FLAG: 0

       N_COLS: 6

        SPACE: 0

   ROW_FORMAT: Redundant

ZIP_PAGE_SIZE: 0

   SPACE_TYPE: System

*************************** 6. row ***************************

     TABLE_ID: 810

         NAME: SYS_ZIP_DICT

         FLAG: 0

       N_COLS: 6

        SPACE: 0

   ROW_FORMAT: Redundant

ZIP_PAGE_SIZE: 0

   SPACE_TYPE: System

*************************** 7. row ***************************

     TABLE_ID: 811

         NAME: SYS_ZIP_DICT_COLS

         FLAG: 0

       N_COLS: 6

        SPACE: 0

   ROW_FORMAT: Redundant

ZIP_PAGE_SIZE: 0

   SPACE_TYPE: System

7 rows in set (0.000 sec)

I know that both of these tables might go away when/if we implement MDEV-11655.

relates to

MDEV-21801 Upstream bug #71725: after upgrading from 5.5, existing tables not present in INNODB_SYS_TABLESPACES

MDEV-21933 INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES accesses SYS_DATAFILES

MDEV-22343 Remove SYS_TABLESPACES and SYS_DATAFILES

MDEV-11655 Transactional data dictionary

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.