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