1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
use data_dictionary;
select * from INNODB_CMPMEM_RESET where PAGE_SIZE > 64;
BUF_POOL PAGE_SIZE PAGES_USED PAGES_FREE RELOCATION_OPS RELOCATION_TIME
0 128 0 0 0 0
0 256 0 0 0 0
0 512 0 0 0 0
0 1024 0 0 0 0
0 2048 0 0 0 0
0 4096 0 0 0 0
0 8192 0 0 0 0
0 16384 0 0 0 0
show create table INNODB_CMPMEM_RESET;
Table Create Table
INNODB_CMPMEM_RESET CREATE TABLE `INNODB_CMPMEM_RESET` (
`BUF_POOL` BIGINT NOT NULL,
`PAGE_SIZE` BIGINT NOT NULL,
`PAGES_USED` BIGINT NOT NULL,
`PAGES_FREE` BIGINT NOT NULL,
`RELOCATION_OPS` BIGINT NOT NULL,
`RELOCATION_TIME` BIGINT NOT NULL
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
|