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 | 2555 | 2612537834016 | 0 | 1022519520 | 212082573120 | 1471 | 29212672 | 19859.0564 | 729 | 32751616 | 44926.7709 | 61964288 | |
sql/io_cache | 588 | 503744242320 | 0 | 856707720 | 327046847952 | 312 | 13361760 | 42826.1538 | 216 | 13361760 | 61860.0000 | 26723520 | |
innodb/innodb_temp_file | 460 | 679618357968 | 0 | 1477431120 | 94196622960 | 0 | 0 | 0.0000 | 394 | 7503872 | 19045.3604 | 7503872 | |
sql/ERRMSG | 50 | 26571833376 | 2380752 | 531436488 | 2469484512 | 30 | 3071469 | 102382.3000 | 0 | 0 | 0.0000 | 3071469 | |
innodb/innodb_log_file | 654 | 3660496507536 | 228096 | 5597089344 | 72033176688 | 8 | 70656 | 8832.0000 | 389 | 329216 | 846.3136 | 399872 | |
mysys/charset | 3 | 236486976 | 2031216 | 78828816 | 223127520 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/dfile | 398 | 9173916576 | 76560 | 23049840 | 8307299088 | 252 | 15192 | 60.2857 | 0 | 0 | 0.0000 | 15192 | |
sql/binlog | 186 | 132768318144 | 0 | 713807952 | 22941955344 | 41 | 907 | 22.1220 | 9 | 1799 | 199.8889 | 2706 | |
myisam/kfile | 16 | 1895830992 | 495264 | 118489272 | 702606960 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
sql/binlog_index | 38 | 65304798768 | 0 | 1718547336 | 39976174656 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2279817408 | 2124672 | 284977176 | 923239680 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 636729456 | 232320 | 127345680 | 611006352 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 43743744 | 2401344 | 14581248 | 34787808 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1266757536 | 0 | 84450432 | 1199616000 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 29108112 | 0 | 9702528 | 11750640 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 549505440 | 0 | 137376360 | 441171456 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|