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 | 2029 | 1013576225904 | 0 | 499544496 | 212227573008 | 1353 | 27279360 | 20162.1286 | 420 | 23511040 | 55978.6667 | 50790400 | |
sql/ERRMSG | 30 | 51397531680 | 2694384 | 1713250968 | 24960319824 | 18 | 1847959 | 102664.3889 | 0 | 0 | 0.0000 | 1847959 | |
innodb/innodb_temp_file | 90 | 340941150000 | 0 | 3788235000 | 35346622080 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | 1146880 | |
innodb/innodb_log_file | 380 | 2037475618992 | 239712 | 5361777696 | 150927402384 | 8 | 70656 | 8832.0000 | 226 | 202240 | 894.8673 | 272896 | |
mysys/charset | 3 | 358809792 | 2439360 | 119603088 | 329934528 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 41 | 35505276048 | 0 | 865982304 | 15920828880 | 7 | 624 | 89.1429 | 3 | 156 | 52.0000 | 780 | |
sql/binlog_index | 38 | 42042741840 | 0 | 1106387832 | 25254459648 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 573747504 | 155232 | 114749448 | 554517216 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 504854592 | 703296 | 126213648 | 408988800 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 18692256 | 1305744 | 6230664 | 13090176 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1508866656 | 0 | 100590864 | 1427685072 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 5328048 | 0 | 5328048 | 5328048 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 9 | 51525408 | 0 | 5724840 | 17335824 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|