SELECT * FROM `x$io_global_by_wait_by_bytes`
|
event_name | total | total_latency | min_latency | avg_latency | max_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | total_requested | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_data_file | 2120 | 1317619550544 | 0 | 621518568 | 251879416800 | 1438 | 28672000 | 19938.8039 | 441 | 24166400 | 54799.0930 | 52838400 | |
sql/ERRMSG | 35 | 18567261504 | 3081936 | 530492952 | 1829436048 | 21 | 2147296 | 102252.1905 | 0 | 0 | 0.0000 | 2147296 | |
innodb/innodb_temp_file | 93 | 397045132176 | 0 | 4269302400 | 30947271168 | 0 | 0 | 0.0000 | 32 | 1245184 | 38912.0000 | 1245184 | |
innodb/innodb_log_file | 424 | 2260780346880 | 231264 | 5332029120 | 76632790080 | 8 | 70656 | 8832.0000 | 250 | 218112 | 872.4480 | 288768 | |
mysys/charset | 3 | 237507600 | 2109360 | 79169112 | 223908432 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 85 | 53375890656 | 0 | 627951456 | 34319600304 | 18 | 668 | 37.1111 | 3 | 156 | 52.0000 | 824 | |
myisam/kfile | 4 | 2611839120 | 2400288 | 652959648 | 2540267136 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 49527827184 | 0 | 1303363776 | 29235324624 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 497655312 | 97680 | 99530904 | 467324352 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 3886937472 | 583968 | 971734368 | 2288548944 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 50563920 | 2946768 | 16854552 | 37407216 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 840492048 | 0 | 56032680 | 762506976 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 11739024 | 0 | 11739024 | 11739024 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 7 | 58120128 | 0 | 8302800 | 18028032 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 125563152 | 1399728 | 62781576 | 124163424 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|