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.332 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) |