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 | 2495 | 3256254735360 | 0 | 1305111984 | 233600086896 | 1370 | 27557888 | 20115.2467 | 744 | 32849920 | 44153.1183 | 60407808 | |
sql/io_cache | 186 | 20788729632 | 0 | 111767304 | 16944504192 | 80 | 4505470 | 56318.3750 | 76 | 4505470 | 59282.5000 | 9010940 | |
innodb/innodb_temp_file | 285 | 518593266576 | 0 | 1819625280 | 28346394912 | 0 | 0 | 0.0000 | 218 | 4685824 | 21494.6055 | 4685824 | |
sql/ERRMSG | 70 | 43224396336 | 2834832 | 617491248 | 2517808128 | 42 | 4296007 | 102285.8810 | 0 | 0 | 0.0000 | 4296007 | |
innodb/innodb_log_file | 563 | 3513252433152 | 216480 | 6240235056 | 176080285392 | 8 | 70656 | 8832.0000 | 323 | 262656 | 813.1765 | 333312 | |
mysys/charset | 3 | 266393424 | 1919808 | 88797720 | 255726240 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/dfile | 28 | 1662396912 | 208560 | 59371224 | 1644325584 | 25 | 1675 | 67.0000 | 0 | 0 | 0.0000 | 1675 | |
sql/binlog | 713 | 36687300672 | 0 | 51454656 | 17030106192 | 175 | 1296 | 7.4057 | 3 | 156 | 52.0000 | 1452 | |
myisam/kfile | 4 | 263652048 | 582912 | 65912880 | 243558480 | 2 | 392 | 196.0000 | 0 | 0 | 0.0000 | 392 | |
sql/binlog_index | 38 | 41669900448 | 0 | 1096576272 | 23833197168 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 800362992 | 195888 | 160072440 | 783258432 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 19198080 | 847440 | 6399360 | 14176272 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1042040208 | 0 | 69469224 | 980291664 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 13551120 | 0 | 13551120 | 13551120 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|