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 | 2672 | 2994674943216 | 0 | 1120761576 | 212082573120 | 1472 | 29229056 | 19856.6957 | 813 | 35241984 | 43348.0738 | 64471040 | |
sql/io_cache | 882 | 537114144864 | 0 | 608972760 | 327046847952 | 468 | 20042640 | 42826.1538 | 324 | 20042640 | 61860.0000 | 40085280 | |
innodb/innodb_temp_file | 736 | 749816070432 | 0 | 1018771776 | 94196622960 | 0 | 0 | 0.0000 | 666 | 12222464 | 18352.0480 | 12222464 | |
sql/ERRMSG | 55 | 28800935328 | 2380752 | 523653240 | 2469484512 | 33 | 3382422 | 102497.6364 | 0 | 0 | 0.0000 | 3382422 | |
innodb/innodb_log_file | 718 | 4065119932896 | 228096 | 5661726840 | 72033176688 | 8 | 70656 | 8832.0000 | 429 | 370176 | 862.8811 | 440832 | |
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 | 200 | 160676433456 | 0 | 803382096 | 22941955344 | 44 | 919 | 20.8864 | 10 | 2027 | 202.7000 | 2946 | |
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 |
|