Debian Codegraph @

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

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