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 | 4461 | 4699298891232 | 0 | 1053418080 | 230358733440 | 1389 | 27869184 | 20064.2073 | 2533 | 90095616 | 35568.7390 | 117964800 | |
sql/io_cache | 1446 | 210958597872 | 0 | 145890888 | 127129271280 | 648 | 34439850 | 53147.9167 | 588 | 34439850 | 58571.1735 | 68879700 | |
innodb/innodb_temp_file | 1885 | 1873547625840 | 0 | 993924360 | 58998639216 | 0 | 0 | 0.0000 | 1746 | 34439168 | 19724.6094 | 34439168 | |
sql/ERRMSG | 45 | 34452825264 | 3315312 | 765618216 | 4023741744 | 27 | 2772767 | 102695.0741 | 0 | 0 | 0.0000 | 2772767 | |
innodb/innodb_log_file | 2087 | 10721108201232 | 229152 | 5137090464 | 37966513200 | 8 | 70656 | 8832.0000 | 1247 | 965120 | 773.9535 | 1035776 | |
mysys/charset | 3 | 247294080 | 3451536 | 82431360 | 227166192 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 271 | 90775497648 | 0 | 334964784 | 23199042240 | 63 | 848 | 13.4603 | 6 | 836 | 139.3333 | 1684 | |
sql/binlog_index | 38 | 53821200048 | 0 | 1416347328 | 35815364640 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 9413016096 | 856944 | 1176626880 | 8554132224 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 859982640 | 210144 | 171996528 | 831023952 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 22796928 | 1093488 | 7598976 | 18620976 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 890187408 | 0 | 59345616 | 788670960 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 42854592 | 0 | 14284776 | 17484192 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 14 | 1646799264 | 0 | 117628368 | 847356576 | 4 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|