|
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.
|