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 | 3660 | 5628031562208 | 0 | 1537713408 | 232041810000 | 1572 | 30867456 | 19635.7863 | 1353 | 51789824 | 38277.7709 | 82657280 | |
sql/io_cache | 294 | 87527777040 | 0 | 297713328 | 41997678096 | 150 | 6899452 | 45996.3467 | 114 | 6899452 | 60521.5088 | 13798904 | |
innodb/innodb_temp_file | 293 | 994187647728 | 0 | 3393131808 | 69038231856 | 0 | 0 | 0.0000 | 206 | 5799936 | 28155.0291 | 5799936 | |
sql/ERRMSG | 65 | 36459247440 | 2137872 | 560911296 | 3777089184 | 39 | 3999279 | 102545.6154 | 0 | 0 | 0.0000 | 3999279 | |
innodb/innodb_log_file | 1208 | 6875688369792 | 213840 | 5691794856 | 64457711472 | 8 | 70656 | 8832.0000 | 710 | 710656 | 1000.9239 | 781312 | |
myisam/dfile | 8310 | 5797835472 | 119856 | 697488 | 704166672 | 7302 | 492896 | 67.5015 | 0 | 0 | 0.0000 | 492896 | |
mysys/charset | 3 | 268271520 | 1820544 | 89423664 | 244578576 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 435 | 359097437952 | 0 | 825511104 | 30576259296 | 95 | 976 | 10.2737 | 24 | 6253 | 260.5417 | 7229 | |
myisam/kfile | 16 | 3351750864 | 477312 | 209484264 | 1566802512 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
sql/binlog_index | 38 | 48782303328 | 0 | 1283744616 | 29529973968 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 618832368 | 264000 | 123766368 | 603602208 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 1612149792 | 1538064 | 403037448 | 1232751168 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 17302032 | 918720 | 5767344 | 13796112 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 915982848 | 0 | 61065312 | 844296816 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 5 | 70391376 | 0 | 14078064 | 20800032 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 30 | 716049840 | 0 | 23868240 | 509553792 | 12 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|