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 | 3204 | 3695867843184 | 0 | 1153516584 | 222902381856 | 1602 | 31358976 | 19574.8914 | 1071 | 43663360 | 40768.7768 | 75022336 | |
sql/ERRMSG | 70 | 38365873392 | 3008016 | 548083800 | 2346293664 | 42 | 4295931 | 102284.0714 | 0 | 0 | 0.0000 | 4295931 | |
innodb/innodb_temp_file | 102 | 445267502592 | 0 | 4365367512 | 27261916704 | 0 | 0 | 0.0000 | 38 | 1540096 | 40528.8421 | 1540096 | |
innodb/innodb_log_file | 875 | 6204145923888 | 243408 | 7090452336 | 905066931648 | 8 | 70656 | 8832.0000 | 517 | 528896 | 1023.0097 | 599552 | |
myisam/dfile | 8310 | 12947641344 | 79200 | 1557864 | 2100353904 | 7302 | 492896 | 67.5015 | 0 | 0 | 0.0000 | 492896 | |
mysys/charset | 3 | 336471168 | 2365968 | 112156968 | 321924240 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 303 | 372549178848 | 0 | 1229535120 | 27673587216 | 63 | 848 | 13.4603 | 22 | 6668 | 303.0909 | 7516 | |
myisam/kfile | 16 | 3928205952 | 925056 | 245512872 | 1497937584 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
sql/binlog_index | 38 | 56208822384 | 0 | 1479179328 | 36694659408 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 10429952016 | 1901328 | 1303743936 | 7978660272 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 651001296 | 341616 | 130200048 | 621183552 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 75352464 | 3503808 | 25117488 | 51041232 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1232783376 | 0 | 82185312 | 1172810496 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 9 | 309826704 | 0 | 34425072 | 189890976 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 760425072 | 0 | 190106136 | 649850784 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|