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