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 | 1885 | 1504264352448 | 0 | 798018144 | 202746214176 | 1282 | 26116096 | 20371.3697 | 366 | 21544960 | 58866.0109 | 47661056 | |
sql/io_cache | 70 | 2517102192 | 0 | 35958384 | 492034224 | 32 | 1583616 | 49488.0000 | 28 | 1583616 | 56557.7143 | 3167232 | |
innodb/innodb_temp_file | 184 | 449476864320 | 0 | 2442808896 | 26739999792 | 0 | 0 | 0.0000 | 122 | 2785280 | 22830.1639 | 2785280 | |
sql/ERRMSG | 40 | 23840672064 | 2920368 | 596016696 | 3293913216 | 24 | 2462945 | 102622.7083 | 0 | 0 | 0.0000 | 2462945 | |
innodb/innodb_log_file | 291 | 1795122984336 | 222288 | 6168807480 | 97752072528 | 8 | 70656 | 8832.0000 | 167 | 172032 | 1030.1317 | 242688 | |
mysys/charset | 3 | 272843472 | 2066064 | 90947736 | 256227312 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 165 | 83905574016 | 0 | 508518384 | 22158749184 | 37 | 744 | 20.1081 | 5 | 790 | 158.0000 | 1534 | |
sql/binlog_index | 38 | 58261484160 | 0 | 1533196896 | 30347190192 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 4649870016 | 521664 | 581233752 | 2975944224 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 640726944 | 210672 | 128145336 | 621221568 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 62633472 | 3052368 | 20877648 | 33979440 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1207863360 | 0 | 80524224 | 1147575264 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 264008976 | 0 | 132004488 | 251344368 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 45088032 | 0 | 11272008 | 19606752 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|