Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.3Mb
PDF (A4) - 40.4Mb
PDF (RPM) - 39.9Mb
HTML Download (TGZ) - 10.6Mb
HTML Download (Zip) - 10.6Mb
HTML Download (RPM) - 9.2Mb
Man Pages (TGZ) - 241.2Kb
Man Pages (Zip) - 346.4Kb
Info (Gzip) - 3.9Mb
Info (Zip) - 3.9Mb
Excerpts from this Manual

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

22.5.14.18 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 disk_write_speed_aggregate table contains the following columns:

  • node_id

    Node ID of this node

  • thr_no

    Thread ID of this LDM thread

  • 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

  • std_dev_backup_lcp_speed_last_10sec

    Standard 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_10sec

    Standard deviation in 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 REDO log per second, averaged over the last 10 seconds

  • std_dev_backup_lcp_speed_last_60sec

    Standard 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_60sec

    Standard deviation in number of bytes written to REDO log per second, averaged over the last 60 seconds

  • slowdowns_due_to_io_lag

    Number of seconds since last node start that disk writes were slowed due to REDO log I/O lag

  • slowdowns_due_to_high_cpu

    Number of seconds since last node start that disk writes were slowed due to high CPU usage

  • disk_write_speed_set_to_min

    Number of seconds since last node start that disk write speed was set to minimum

  • current_target_disk_write_speed

    Actual speed of disk writes per LDM thread (aggregated)