CREATE TEMPORARY TABLE `INNODB_SYS_TABLESPACES` (
`SPACE` int(11) unsigned NOT NULL DEFAULT '0',
`NAME` varchar(655) NOT NULL DEFAULT '',
`FLAG` int(11) unsigned NOT NULL DEFAULT '0',
`FILE_FORMAT` varchar(10) DEFAULT NULL,
`ROW_FORMAT` varchar(22) DEFAULT NULL,
`PAGE_SIZE` int(11) unsigned NOT NULL DEFAULT '0',
`ZIP_PAGE_SIZE` int(11) unsigned NOT NULL DEFAULT '0',
`SPACE_TYPE` varchar(10) DEFAULT NULL,
`FS_BLOCK_SIZE` int(11) unsigned NOT NULL DEFAULT '0',
`FILE_SIZE` bigint(21) unsigned NOT NULL DEFAULT '0',
`ALLOCATED_SIZE` bigint(21) unsigned NOT NULL DEFAULT '0'
) ENGINE=MEMORY DEFAULT CHARSET=utf8
admin@localhost : information_schema 06:48:10> select * from INNODB_SYS_TABLESPACES where name like '%sbtest%' limit 10;
+-------+------------------------------------------------------+------+-------------+------------+-----------+---------------+------------+---------------+------------+----------------+
| SPACE | NAME | FLAG | FILE_FORMAT | ROW_FORMAT | PAGE_SIZE | ZIP_PAGE_SIZE | SPACE_TYPE | FS_BLOCK_SIZE | FILE_SIZE | ALLOCATED_SIZE |
+-------+------------------------------------------------------+------+-------------+------------+-----------+---------------+------------+---------------+------------+----------------+
| 28 | sbtest/sbtest6 | 33 | Barracuda | Dynamic | 16384 | 0 | Single | 4096 | 1547698176 | 1547702272 |
| 29 | sbtest/sbtest5 | 33 | Barracuda | Dynamic | 16384 | 0 | Single | 4096 | 1551892480 | 1551896576 |
| 30 | sbtest/sbtest3 | 33 | Barracuda | Dynamic | 16384 | 0 | Single | 4096 | 1551892480 | 1551896576 |
| 31 | sbtest/sbtest7 | 33 | Barracuda | Dynamic | 16384 | 0 | Single | 4096 | 1547698176 | 1547702272 |
| 32 | sbtest/sbtest1 | 33 | Barracuda | Dynamic | 16384 | 0 | Single | 4096 | 2533359616 | 2533363712 |
| 33 | sbtest/sbtest2 | 33 | Barracuda | Dynamic | 16384 | 0 | Single | 4096 | 1547698176 | 1547702272 |
| 34 | sbtest/sbtest4 | 33 | Barracuda | Dynamic | 16384 | 0 | Single | 4096 | 1551892480 | 1551896576 |
| 35 | sbtest/sbtest8 | 33 | Barracuda | Dynamic | 16384 | 0 | Single | 4096 | 1547698176 | 1547702272 |
| 167 | sbtest/xx | 33 | Barracuda | Dynamic | 16384 | 0 | Single | 4096 | 114688 | 114688 |
| 168 | sbtest/FTS_0000000000000076_000000000000008e_INDEX_1 | 33 | Barracuda | Dynamic | 16384 | 0 | Single | 4096 | 98304 | 98304 |
+-------+------------------------------------------------------+------+-------------+------------+-----------+---------------+------------+---------------+------------+----------------+
10 rows in set (0.00 sec)