Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.6, 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
-
None
Description
InnoDB I_S queries displays innodb_system for undo tablespaces.
select * from information_schema.innodb_sys_tablespaces;
|
SPACE NAME FLAG ROW_FORMAT PAGE_SIZE FILENAME FS_BLOCK_SIZE FILE_SIZE ALLOCATED_SIZE
|
0 innodb_system 21 NULL 16384 ./ibdata1 4096 12582912 12582912
|
1 innodb_system 21 NULL 16384 .//undo001 4096 10485760 10485760
|
2 innodb_system 21 NULL 16384 .//undo002 4096 10485760 10485760
|
3 innodb_system 21 NULL 16384 .//undo003 4096 10485760 10485760
|
innodb_undo001, innodb_undo002 etc should be displayed for undo tablespaces