Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6, 10.3(EOL), 10.4(EOL)
-
None
Description
Innodb_sys_tablespaces view in information schema doesn't show temporary tablespace
information. The following is the output of information schema output
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 mysql/innodb_table_stats 21 NULL 16384 ./mysql/innodb_table_stats.ibd 4096 65536 65536
|
2 mysql/innodb_index_stats 21 NULL 16384 ./mysql/innodb_index_stats.ibd 4096 65536 65536
|
3 mysql/transaction_registry 21 NULL 16384 ./mysql/transaction_registry.ibd 4096 114688 114688
|
5 test/t 21 NULL 16384 ./test/t.ibd 4096 81920 81920
|
Above output should include temporary tablespace information with space as 0xFFFFFFFE