MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
The disk_write_speed_aggregate_node table
provides aggregated information per node about the speed of disk
writes during LCP, backup, and restore operations.
As of NDB 7.4.3, the
disk_write_speed_aggregate_node contains the
following columns (information relating to NDB 7.4.2 and earlier
can be found later in this section):
node_id
Node ID of this node
backup_lcp_speed_last_sec
Number of bytes written to disk by backup and LCP processes in the last second
redo_speed_last_sec
Number of bytes written to REDO log in the last second
backup_lcp_speed_last_10sec
Number of bytes written to disk by backup and LCP processes per second, averaged over the last 10 seconds
redo_speed_last_10sec
Number of bytes written to REDO log per second, averaged over the last 10 seconds
backup_lcp_speed_last_60sec
Number of bytes written to disk by backup and LCP processes per second, averaged over the last 60 seconds
redo_speed_last_60sec
Number of bytes written to disk by backup and LCP processes per second, averaged over the last 60 seconds
Prior to NDB 7.4.3, columns of this table showed values in
kilobytes. (In NDB 7.4.3 and later, the columns display all such
values in bytes.) (Bug #74317, Bug #19795072) In NDB 7.4.2 and
earlier, the disk_write_speed_aggregate
contains the following columns:
node_id
Node ID of this node
backup_lcp_speed_last_sec
Number of kilobytes written to disk by backup and LCP processes in the last second
redo_speed_last_sec
Number of kilobytes written to REDO log in the last second
backup_lcp_speed_last_10sec
Number of kilobytes written to disk by backup and LCP processes per second, averaged over the last 10 seconds
redo_speed_last_10sec
Number of kilobytes written to REDO log per second, averaged over the last 10 seconds
backup_lcp_speed_last_60sec
Number of kilobytes written to disk by backup and LCP processes per second, averaged over the last 60 seconds
redo_speed_last_60sec
Number of kilobytes written to disk by backup and LCP processes per second, averaged over the last 60 seconds
The disk_write_speed_aggregate_node table was
added in NDB 7.4.1.