Debian Codegraph @

mysql-test/suite/sysschema/r/v_innodb_buffer_stats_by_table.result

raw
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;