No cache version.
Caching disabled. Default setting for this page:enabled (code DEF204)If the display is too slow, you can disable the user mode to view the cached version.
Rechercher dans le manuel MySQL
22.5.10.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 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.
Table 22.392 Columns in the disk_write_speed_aggregate table
Column Name | Type | Description |
---|---|---|
node_id | integer | Node ID of this node |
thr_no | integer | Thread ID of this LDM thread |
backup_lcp_speed_last_sec | integer | Number of bytes written to disk by backup and LCP processes in the last second |
redo_speed_last_sec | integer | Number of bytes written to REDO log in the last second |
backup_lcp_speed_last_10sec | integer | Number of bytes written to disk by backup and LCP processes per second, averaged over the last 10 seconds |
redo_speed_last_10sec | integer | Number of bytes written to REDO log per second, averaged over the last 10 seconds |
std_dev_backup_lcp_speed_last_10sec | integer | 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 | integer | Standard deviation in number of bytes written to REDO log per second, averaged over the last 10 seconds |
backup_lcp_speed_last_60sec | integer | Number of bytes written to disk by backup and LCP processes per second, averaged over the last 60 seconds |
redo_speed_last_60sec | integer | Number of bytes written to REDO log per second, averaged over the last 10 seconds |
std_dev_backup_lcp_speed_last_60sec | integer | 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 | integer | Standard deviation in number of bytes written to REDO log per second, averaged over the last 60 seconds |
slowdowns_due_to_io_lag | integer | Number of seconds since last node start that disk writes were slowed due to REDO log I/O lag |
slowdowns_due_to_high_cpu | integer | Number of seconds since last node start that disk writes were slowed due to high CPU usage |
disk_write_speed_set_to_min | integer | Number of seconds since last node start that disk write speed was set to minimum |
current_target_disk_write_speed | integer | Actual speed of disk writes per LDM thread (aggregated) |
Can not display this page of the Infobrol website
Type of error (18-01)
Unknown format specifier "&"Please try again in a few minutes…
Steph