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 | 1474 | 725766590736 | 0 | 492378744 | 227969338080 | 1145 | 23871488 | 20848.4611 | 174 | 15613952 | 89735.3563 | 39485440 | |
innodb/innodb_temp_file | 126 | 540423968832 | 0 | 4289078904 | 169557488496 | 0 | 0 | 0.0000 | 65 | 1785856 | 27474.7077 | 1785856 | |
sql/ERRMSG | 25 | 13809238080 | 2274096 | 552369312 | 3785032416 | 15 | 1544829 | 102988.6000 | 0 | 0 | 0.0000 | 1544829 | |
innodb/innodb_log_file | 65 | 392791505040 | 229152 | 6042946008 | 53943757296 | 8 | 70656 | 8832.0000 | 31 | 51712 | 1668.1290 | 122368 | |
mysys/charset | 3 | 318772080 | 2067120 | 106257360 | 306293856 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 47 | 62051292336 | 0 | 1320240240 | 21841113888 | 8 | 628 | 78.5000 | 4 | 397 | 99.2500 | 1025 | |
sql/binlog_index | 38 | 49332617664 | 0 | 1298226600 | 25894950576 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 637760640 | 174240 | 127552128 | 619283808 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 34666896 | 2223408 | 11555544 | 27151872 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1107888144 | 0 | 73859016 | 1046285856 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 24021888 | 0 | 12010944 | 13185216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|