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 | 2119 | 1544317620912 | 0 | 728795232 | 195974418288 | 1264 | 25821184 | 20428.1519 | 574 | 28131328 | 49009.2822 | 53952512 | |
innodb/innodb_temp_file | 370 | 1115333241264 | 0 | 3014414040 | 283298567376 | 0 | 0 | 0.0000 | 298 | 6324224 | 21222.2282 | 6324224 | |
sql/io_cache | 54 | 2476082928 | 0 | 45853368 | 1474622160 | 20 | 1418656 | 70932.8000 | 24 | 1418656 | 59110.6667 | 2837312 | |
sql/ERRMSG | 30 | 16346872080 | 3252480 | 544895736 | 2518664016 | 18 | 1848800 | 102711.1111 | 0 | 0 | 0.0000 | 1848800 | |
innodb/innodb_log_file | 389 | 1889510637696 | 234432 | 4857353688 | 31704223056 | 8 | 70656 | 8832.0000 | 224 | 201728 | 900.5714 | 272384 | |
mysys/charset | 3 | 305534064 | 3098832 | 101844600 | 288990768 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 117 | 39345604320 | 0 | 336287160 | 20123708352 | 26 | 700 | 26.9231 | 3 | 156 | 52.0000 | 856 | |
sql/binlog_index | 38 | 55336979280 | 0 | 1456236144 | 28889379024 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 423623904 | 144672 | 84724728 | 405869904 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 3376700976 | 764016 | 844175112 | 1907104848 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 12032064 | 610896 | 4010688 | 9714672 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 895852848 | 0 | 59723400 | 813221904 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 4783152 | 0 | 4783152 | 4783152 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 18081888 | 0 | 9040944 | 11591184 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|