Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.4Mb
PDF (A4) - 37.4Mb
PDF (RPM) - 37.0Mb
EPUB - 10.6Mb
HTML Download (TGZ) - 10.3Mb
HTML Download (Zip) - 10.4Mb
HTML Download (RPM) - 9.0Mb
Eclipse Doc Plugin (TGZ) - 11.2Mb
Eclipse Doc Plugin (Zip) - 13.4Mb
Man Pages (TGZ) - 204.7Kb
Man Pages (Zip) - 311.8Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  ...  /  The ndbinfo disk_write_speed_aggregate Table

20.5.10.17 The ndbinfo disk_write_speed_aggregate Table

The disk_write_speed_aggregate table provides aggregated information 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 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.

Column NameTypeDescription
node_idintegerNode ID of this node
thr_nointegerThread ID of this LDM thread
backup_lcp_speed_last_secintegerNumber of bytes written to disk by backup and LCP processes in the last second
redo_speed_last_secintegerNumber of bytes written to REDO log in the last second
backup_lcp_speed_last_10secintegerNumber of bytes written to disk by backup and LCP processes per second, averaged over the last 10 seconds
redo_speed_last_10secintegerNumber of bytes written to REDO log per second, averaged over the last 10 seconds
std_dev_backup_lcp_speed_last_10secintegerStandard deviation in number of bytes written to disk by backup and LCP processes per second, averaged over the last 10 seconds
std_dev_redo_speed_last_10secintegerStandard deviation in number of bytes written to REDO log per second, averaged over the last 10 seconds
backup_lcp_speed_last_60secintegerNumber of bytes written to disk by backup and LCP processes per second, averaged over the last 60 seconds
redo_speed_last_60secintegerNumber of bytes written to REDO log per second, averaged over the last 10 seconds
std_dev_backup_lcp_speed_last_60secintegerStandard deviation in number of bytes written to disk by backup and LCP processes per second, averaged over the last 60 seconds
std_dev_redo_speed_last_60secintegerStandard deviation in number of bytes written to REDO log per second, averaged over the last 60 seconds
slowdowns_due_to_io_lagintegerNumber of seconds since last node start that disk writes were slowed due to REDO log I/O lag
slowdowns_due_to_high_cpuintegerNumber of seconds since last node start that disk writes were slowed due to high CPU usage
disk_write_speed_set_to_minintegerNumber of seconds since last node start that disk write speed was set to minimum
current_target_disk_write_speedintegerActual speed of disk writes per LDM thread (aggregated)

User Comments
Sign Up Login You must be logged in to post a comment.