1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
SHOW CREATE TABLE INFORMATION_SCHEMA.INNODB_BUFFER_POOL_STATS;
Table Create Table
INNODB_BUFFER_POOL_STATS CREATE TEMPORARY TABLE `INNODB_BUFFER_POOL_STATS` (
`POOL_ID` int(11) unsigned NOT NULL DEFAULT 0,
`POOL_SIZE` bigint(21) unsigned NOT NULL DEFAULT 0,
`FREE_BUFFERS` bigint(21) unsigned NOT NULL DEFAULT 0,
`DATABASE_PAGES` bigint(21) unsigned NOT NULL DEFAULT 0,
`OLD_DATABASE_PAGES` bigint(21) unsigned NOT NULL DEFAULT 0,
`MODIFIED_DATABASE_PAGES` bigint(21) unsigned NOT NULL DEFAULT 0,
`PENDING_DECOMPRESS` bigint(21) unsigned NOT NULL DEFAULT 0,
`PENDING_READS` bigint(21) unsigned NOT NULL DEFAULT 0,
`PENDING_FLUSH_LRU` bigint(21) unsigned NOT NULL DEFAULT 0,
`PENDING_FLUSH_LIST` bigint(21) unsigned NOT NULL DEFAULT 0,
`PAGES_MADE_YOUNG` bigint(21) unsigned NOT NULL DEFAULT 0,
`PAGES_NOT_MADE_YOUNG` bigint(21) unsigned NOT NULL DEFAULT 0,
`PAGES_MADE_YOUNG_RATE` float NOT NULL DEFAULT 0,
`PAGES_MADE_NOT_YOUNG_RATE` float NOT NULL DEFAULT 0,
`NUMBER_PAGES_READ` bigint(21) unsigned NOT NULL DEFAULT 0,
`NUMBER_PAGES_CREATED` bigint(21) unsigned NOT NULL DEFAULT 0,
`NUMBER_PAGES_WRITTEN` bigint(21) unsigned NOT NULL DEFAULT 0,
`PAGES_READ_RATE` float NOT NULL DEFAULT 0,
`PAGES_CREATE_RATE` float NOT NULL DEFAULT 0,
`PAGES_WRITTEN_RATE` float NOT NULL DEFAULT 0,
`NUMBER_PAGES_GET` bigint(21) unsigned NOT NULL DEFAULT 0,
`HIT_RATE` bigint(21) unsigned NOT NULL DEFAULT 0,
`YOUNG_MAKE_PER_THOUSAND_GETS` bigint(21) unsigned NOT NULL DEFAULT 0,
`NOT_YOUNG_MAKE_PER_THOUSAND_GETS` bigint(21) unsigned NOT NULL DEFAULT 0,
`NUMBER_PAGES_READ_AHEAD` bigint(21) unsigned NOT NULL DEFAULT 0,
`NUMBER_READ_AHEAD_EVICTED` bigint(21) unsigned NOT NULL DEFAULT 0,
`READ_AHEAD_RATE` float NOT NULL DEFAULT 0,
`READ_AHEAD_EVICTED_RATE` float NOT NULL DEFAULT 0,
`LRU_IO_TOTAL` bigint(21) unsigned NOT NULL DEFAULT 0,
`LRU_IO_CURRENT` bigint(21) unsigned NOT NULL DEFAULT 0,
`UNCOMPRESS_TOTAL` bigint(21) unsigned NOT NULL DEFAULT 0,
`UNCOMPRESS_CURRENT` bigint(21) unsigned NOT NULL DEFAULT 0
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3
|
