Skip to content

The INNODB_SPACE_STATS table

Liang G edited this page · 2 revisions

The INNODB_SPACE_STATS tables provides statistics counters for InnoDB tablespaces. These statistics represent low-level counters for the number of read, write or flush operations. The counters are incremented whenever a request is made to read, write or flush data to an InnoDB tablespace.

InnoDB spaces are represented in this table if they have been opened since the server was started, and not aged out of the tablespace memory cache. In the unlikely case a tablespace is removed from the cache, the counters values are lost.

Column name Description
SPACE Tablespace ID.
SPACE_NAME File path of the ibd file.
READ_REQS The number of requests to read data from the tablespace.
READ_BYTES The number of bytes read from the tablespace.
WRITE_REQS The number of requests to write data to the tablespace.
WRITE_BYTES The number of bytes written to the tablespace.
FLUSH_REQS The number of requests to flush tablespace data to the storage layer.
EXTEND_REQS The number of requests to extend tablespace file.
EXTEND_BYTES The number of bytes that a tablespace file had been extended.
Something went wrong with that request. Please try again.