MySQL 5.7 Release Notes
The disk_write_speed_base
table provides base
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_base
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 21.386 Columns of the disk_write_speed_base table
Column Name | Type | Description |
---|---|---|
node_id | integer | Node ID of this node |
thr_no | integer | Thread ID of this LDM thread |
millis_ago | integer | Milliseconds since this reporting period ended |
millis_passed | integer | Milliseconds elapsed in this reporting period |
backup_lcp_bytes_written | integer | Number of bytes written to disk by local checkpoints and backup processes during this period |
redo_bytes_written | integer | Number of bytes written to REDO log during this period |
target_disk_write_speed | integer | Actual speed of disk writes per LDM thread (base data) |