information_schema.innodb_buffer_page.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
innodb_buffer_page |
||||||||
access_time |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
block_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
compressed_size |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
data_size |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
fix_count |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
flush_type |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
free_page_clock |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
index_name |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
io_fix |
VARCHAR NULL:
5.7-8
| ENUM NOT NULL:
10.5-10.7
VARCHAR NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
is_hashed |
VARCHAR NULL:
5.7-8
| INT NOT NULL:
10.5-10.7
VARCHAR NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
is_old |
VARCHAR NULL:
5.7-8
| INT NOT NULL:
10.5-10.7
VARCHAR NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
is_stale |
VARCHAR NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
newest_modification |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
number_records |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
oldest_modification |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
page_number |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
page_state |
VARCHAR NULL:
5.7-8
| ENUM NOT NULL:
10.5-10.7
VARCHAR NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
page_type |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
pool_id |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
space |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_name |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||