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 | 2068 | 1663348691664 | 0 | 804327216 | 209963130432 | 1270 | 25919488 | 20409.0457 | 517 | 26296320 | 50863.2882 | 52215808 | |
innodb/innodb_temp_file | 259 | 1418370913872 | 0 | 5476335480 | 29505061344 | 0 | 0 | 0.0000 | 142 | 6717440 | 47305.9155 | 6717440 | |
sql/ERRMSG | 95 | 57765916560 | 2967360 | 608062224 | 7861215120 | 57 | 5827242 | 102232.3158 | 0 | 0 | 0.0000 | 5827242 | |
innodb/innodb_log_file | 332 | 1971642472272 | 233376 | 5938682112 | 106893378240 | 8 | 70656 | 8832.0000 | 192 | 180224 | 938.6667 | 250880 | |
mysys/charset | 3 | 239641776 | 2047584 | 79880592 | 225572688 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/dfile | 82 | 1330190928 | 104544 | 16221744 | 1289733456 | 50 | 2973 | 59.4600 | 0 | 0 | 0.0000 | 2973 | |
sql/binlog | 593 | 43496612016 | 0 | 73350024 | 21986540928 | 145 | 1176 | 8.1103 | 3 | 156 | 52.0000 | 1332 | |
myisam/kfile | 8 | 2559552864 | 474672 | 319943976 | 1585915056 | 4 | 849 | 212.2500 | 0 | 0 | 0.0000 | 849 | |
sql/binlog_index | 38 | 59406818592 | 0 | 1563337248 | 32345596800 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 2068640640 | 198528 | 413728128 | 2052183408 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 1412311296 | 1763520 | 353077824 | 1107187488 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 70425168 | 3284688 | 23474880 | 49750800 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 976093008 | 0 | 65072832 | 894393984 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 13514688 | 0 | 13514688 | 13514688 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 51872832 | 0 | 25936416 | 38362368 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|