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 | 1746 | 1187832677856 | 0 | 680316384 | 198941688000 | 1195 | 24690688 | 20661.6636 | 323 | 20103168 | 62238.9102 | 44793856 | |
sql/ERRMSG | 55 | 27786175824 | 1958880 | 505203072 | 2658657408 | 33 | 3381085 | 102457.1212 | 0 | 0 | 0.0000 | 3381085 | |
innodb/innodb_temp_file | 114 | 455992458768 | 0 | 3999933696 | 28198923984 | 0 | 0 | 0.0000 | 46 | 1933312 | 42028.5217 | 1933312 | |
innodb/innodb_log_file | 302 | 1700205456576 | 317328 | 5629819272 | 90038869536 | 8 | 70656 | 8832.0000 | 166 | 145920 | 879.0361 | 216576 | |
mysys/charset | 3 | 293037360 | 2397120 | 97678944 | 278151456 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 213 | 68709915648 | 0 | 322581600 | 19847356848 | 49 | 792 | 16.1633 | 5 | 696 | 139.2000 | 1488 | |
sql/binlog_index | 38 | 41115016800 | 0 | 1081973904 | 25218422592 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1929449808 | 188496 | 385889856 | 1911889584 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 22534512 | 1168992 | 7511328 | 15402288 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 722307696 | 0 | 48153600 | 659409168 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 26204112 | 0 | 8734704 | 12591216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|