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 | 3119 | 2548475890224 | 0 | 817081056 | 219931059744 | 1355 | 27312128 | 20156.5520 | 1254 | 49889280 | 39784.1148 | 77201408 | |
sql/io_cache | 57 | 3328297104 | 0 | 58390992 | 1739247840 | 18 | 1292122 | 71784.5556 | 24 | 1292122 | 53838.4167 | 2584244 | |
innodb/innodb_log_file | 1771 | 7608156551424 | 234960 | 4295966400 | 85036773888 | 8 | 70656 | 8832.0000 | 1220 | 2277376 | 1866.7016 | 2348032 | |
sql/ERRMSG | 35 | 24358207104 | 2842752 | 695948616 | 3405546144 | 21 | 2160943 | 102902.0476 | 0 | 0 | 0.0000 | 2160943 | |
innodb/innodb_temp_file | 102 | 407857573728 | 0 | 3998603664 | 28727671104 | 0 | 0 | 0.0000 | 38 | 1540096 | 40528.8421 | 1540096 | |
mysys/charset | 3 | 245750208 | 1512192 | 81916560 | 233035440 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 269 | 490458252240 | 0 | 1823264784 | 37960388400 | 49 | 792 | 16.1633 | 33 | 6283 | 190.3939 | 7075 | |
myisam/kfile | 24 | 5180027424 | 0 | 215834256 | 1634757168 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
sql/binlog_index | 38 | 59479933392 | 0 | 1565261280 | 42070029936 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1721337552 | 696960 | 215167128 | 598319568 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1900982160 | 143616 | 380196432 | 1883947824 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13196832 | 661584 | 4398768 | 10648704 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 905744928 | 0 | 60382872 | 808281408 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 3173808 | 0 | 3173808 | 3173808 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 8 | 80228544 | 0 | 10028568 | 39834432 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 16 | 376189968 | 0 | 23511840 | 204653856 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|