| 1 |
DESC sys.innodb_buffer_stats_by_schema; |
| 2 |
Field Type Null Key Default Extra |
| 3 |
object_schema text YES NULL |
| 4 |
allocated varchar(14) YES NULL |
| 5 |
data varchar(14) YES NULL |
| 6 |
pages bigint(21) NO 0 |
| 7 |
pages_hashed bigint(21) NO 0 |
| 8 |
pages_old bigint(21) NO 0 |
| 9 |
rows_cached decimal(44,0) YES NULL |
| 10 |
CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB; |
| 11 |
SELECT * FROM sys.innodb_buffer_stats_by_schema |
| 12 |
where object_schema = 'test'; |
| 13 |
object_schema allocated data pages pages_hashed pages_old rows_cached |
| 14 |
test 16.00 KiB 0 bytes 1 0 0 0 |
| 15 |
DESC sys.x$innodb_buffer_stats_by_schema; |
| 16 |
Field Type Null Key Default Extra |
| 17 |
object_schema text YES NULL |
| 18 |
allocated decimal(43,0) YES NULL |
| 19 |
data decimal(43,0) YES NULL |
| 20 |
pages bigint(21) NO 0 |
| 21 |
pages_hashed bigint(21) NO 0 |
| 22 |
pages_old bigint(21) NO 0 |
| 23 |
rows_cached decimal(44,0) NO 0 |
| 24 |
SELECT * FROM sys.x$innodb_buffer_stats_by_schema |
| 25 |
where object_schema = 'test'; |
| 26 |
object_schema allocated data pages pages_hashed pages_old rows_cached |
| 27 |
test 16384 0 1 0 0 0 |
| 28 |
DROP TABLE t1; |