SELECT * FROM `x$io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_log_file | 2319 | 11967590501328 | 5160668568 | 37966513200 | 1344595296 | 280985551440 | 11685260354592 | 8 | 70656 | 8832.0000 | 1387 | 1096704 | 790.7022 | |
innodb/innodb_data_file | 4879 | 5321586308016 | 1090712304 | 230358733440 | 221138161200 | 69271124736 | 5031177022080 | 1395 | 27967488 | 20048.3785 | 2883 | 101105664 | 35069.6025 | |
innodb/innodb_temp_file | 2209 | 2211441921216 | 1001105424 | 58998639216 | 0 | 113843886288 | 2097598034928 | 0 | 0 | 0.0000 | 2050 | 40730624 | 19868.5971 | |
sql/io_cache | 1680 | 234189592560 | 139398336 | 127129271280 | 4020263280 | 24549020496 | 205620308784 | 756 | 40077358 | 53012.3783 | 684 | 40077358 | 58592.6287 | |
sql/binlog | 365 | 113045660640 | 309713976 | 23199042240 | 6003647232 | 3287789472 | 103754223936 | 86 | 940 | 10.9302 | 7 | 1144 | 163.4286 | |
sql/binlog_index | 38 | 53821200048 | 1416347328 | 35815364640 | 1567919232 | 0 | 52253280816 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 45 | 34452825264 | 765618216 | 4023741744 | 16760539488 | 0 | 17692285776 | 27 | 2772767 | 102695.0741 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 9413016096 | 1176626880 | 8554132224 | 647152176 | 0 | 8765863920 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 14 | 1646799264 | 117628368 | 847356576 | 25997136 | 0 | 1620802128 | 4 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 890187408 | 59345616 | 788670960 | 0 | 0 | 890187408 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 859982640 | 171996528 | 831023952 | 832502880 | 0 | 27479760 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 247294080 | 82431360 | 227166192 | 227166192 | 0 | 20127888 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 42854592 | 14284776 | 17484192 | 0 | 0 | 42854592 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 22796928 | 7598976 | 18620976 | 0 | 3082464 | 19714464 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|