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 | 1694 | 956462196096 | 0 | 564617328 | 198941688000 | 1191 | 24625152 | 20676.0302 | 297 | 19415040 | 65370.5051 | 44040192 | |
sql/ERRMSG | 55 | 27786175824 | 1958880 | 505203072 | 2658657408 | 33 | 3381085 | 102457.1212 | 0 | 0 | 0.0000 | 3381085 | |
innodb/innodb_temp_file | 108 | 412559854608 | 0 | 3819998424 | 28198923984 | 0 | 0 | 0.0000 | 42 | 1736704 | 41350.0952 | 1736704 | |
innodb/innodb_log_file | 257 | 1370239381632 | 317328 | 5331670608 | 90038869536 | 8 | 70656 | 8832.0000 | 141 | 133120 | 944.1135 | 203776 | |
mysys/charset | 3 | 293037360 | 2397120 | 97678944 | 278151456 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 179 | 54658782816 | 0 | 305356128 | 19847356848 | 41 | 760 | 18.5366 | 4 | 426 | 106.5000 | 1186 | |
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 | 2 | 13612896 | 0 | 6806448 | 10479216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|