Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 47.6Mb
PDF (A4) - 47.7Mb
PDF (RPM) - 43.1Mb
HTML Download (TGZ) - 10.9Mb
HTML Download (Zip) - 11.0Mb
HTML Download (RPM) - 9.5Mb
Man Pages (TGZ) - 233.8Kb
Man Pages (Zip) - 338.8Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

22.5.10.21 The ndbinfo diskstat Table

The diskstat table provides information about writes to Disk Data tablespaces during the past 1 second.

The following table provides information about the columns in the diskstat table. For each column, the table shows the name, data type, and a brief description. Additional information can be found in the notes following the table.

Table 22.310 Columns of the diskstat table

Column Name Type Description
node_id integer Node ID of this node
block_instance integer ID of reporting instance of PGMAN
pages_made_dirty integer Number of pages made dirty during the past second
reads_issued integer Reads issued during the past second
reads_completed integer Reads completed during the past second
writes_issued integer Writes issued during the past second
writes_completed integer Writes completed during the past second
log_writes_issued integer Number of times a page write has required a log write during the past second
log_writes_completed integer Number of log writes completed during the last second
get_page_calls_issued integer Number of get_page() calls issued during the past second
get_page_reqs_issued integer Number of times that a get_page() call has resulted in a wait for I/O or completion of I/O already begun during the past second
get_page_reqs_completed integer Number of get_page() calls waiting for I/O or I/O completion that have completed during the past second

Each row in this table corresponds to an instance of PGMAN; there is one such instance per LDM thread plus an additional instance for each data node.

The diskstat table was added in NDB 8.0.19.