Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 47.5Mb
PDF (A4) - 47.6Mb
PDF (RPM) - 43.0Mb
HTML Download (TGZ) - 10.9Mb
HTML Download (Zip) - 11.0Mb
HTML Download (RPM) - 9.4Mb
Man Pages (TGZ) - 231.9Kb
Man Pages (Zip) - 337.3Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

22.5.10.22 The ndbinfo diskstats_1sec Table

The diskstats_1sec table provides information about writes to Disk Data tablespaces over the past 20 seconds.

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.341 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 Pages made dirty during the designated 1-second interval
reads_issued integer Reads issued during the designated 1-second interval
reads_completed integer Reads completed during the designated 1-second interval
writes_issued integer Writes issued during the designated 1-second interval
writes_completed integer Writes completed during the designated 1-second interval
log_writes_issued integer Number of times a page write has required a log write during the designated 1-second interval
log_writes_completed integer Number of log writes completed during the designated 1-second interval
get_page_calls_issued integer Number of get_page() calls issued during the designated 1-second interval
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 designated 1-second interval
get_page_reqs_completed integer Number of get_page() calls waiting for I/O or I/O completion that have completed during the designated 1-second interval
seconds_ago integer Number of 1-second intervals in the past of the interval to which this row applies

Each row in this table corresponds to an instance of PGMAN during a 1-second interval occurring from 0 to 19 seconds ago; there is one such instance per LDM thread plus an additional instance for each data node.

The diskstats_1sec table was added in NDB 8.0.19.