MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

22.5.10.19 The ndbinfo disk_write_speed_aggregate_node Table

The disk_write_speed_aggregate_node table provides aggregated information per node about the speed of disk writes during LCP, backup, and restore operations.

The following table provides information about the columns in the disk_write_speed_aggregate_node 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.384 Columns of the disk_write_speed_aggregate_node table

Column Name Type Description
node_id integer Node ID of this node
backup_lcp_speed_last_sec integer Number of bytes written to disk by backup and LCP processes in the last second
redo_speed_last_sec integer Number of bytes written to REDO log in the last second
backup_lcp_speed_last_10sec integer Number of bytes written to disk by backup and LCP processes per second, averaged over the last 10 seconds
redo_speed_last_10sec integer Number of bytes written to REDO log per second, averaged over the last 10 seconds
backup_lcp_speed_last_60sec integer Number of bytes written to disk by backup and LCP processes per second, averaged over the last 60 seconds
redo_speed_last_60sec integer Number of bytes written to disk by backup and LCP processes per second, averaged over the last 60 seconds