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

System tablespace is not listed in information_schema.INNODB_SYS_TABLESPACES

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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