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 | 2275 | 2159351495664 | 0 | 949165272 | 259524891648 | 1414 | 28278784 | 19999.1400 | 516 | 25935872 | 50263.3178 | 54214656 | |
sql/ERRMSG | 40 | 20514937344 | 2867040 | 512873328 | 3027413664 | 24 | 2466220 | 102759.1667 | 0 | 0 | 0.0000 | 2466220 | |
innodb/innodb_temp_file | 108 | 499694299104 | 0 | 4626799056 | 31753138032 | 0 | 0 | 0.0000 | 42 | 1736704 | 41350.0952 | 1736704 | |
innodb/innodb_log_file | 391 | 2529976027392 | 222816 | 6470526744 | 175873857984 | 8 | 70656 | 8832.0000 | 218 | 184320 | 845.5046 | 254976 | |
myisam/dfile | 6004 | 2002886160 | 74976 | 333432 | 334881360 | 4000 | 237696 | 59.4240 | 0 | 0 | 0.0000 | 237696 | |
mysys/charset | 3 | 321263184 | 2101440 | 107087640 | 305890464 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 1167 | 94342819824 | 0 | 80842080 | 22464490752 | 287 | 1744 | 6.0767 | 6 | 898 | 149.6667 | 2642 | |
myisam/kfile | 4 | 586049376 | 813120 | 146512344 | 562832688 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 56891617728 | 0 | 1497147696 | 31417277760 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 594977328 | 177936 | 118995360 | 579614640 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 47929728 | 2685408 | 15976488 | 37809024 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1051811376 | 0 | 70120512 | 985747488 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 623717952 | 0 | 155929488 | 585370896 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|