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 | 2139 | 11015422107360 | 5149799952 | 37966513200 | 1344595296 | 248938373376 | 10765139138688 | 8 | 70656 | 8832.0000 | 1279 | 989184 | 773.4042 | |
innodb/innodb_data_file | 4505 | 4780032010512 | 1061050320 | 230358733440 | 218484254208 | 59978842176 | 4501568914128 | 1389 | 27869184 | 20064.2073 | 2570 | 91242496 | 35502.9167 | |
innodb/innodb_temp_file | 1985 | 1933464344064 | 974037240 | 58998639216 | 0 | 111469562160 | 1821994781904 | 0 | 0 | 0.0000 | 1843 | 36225024 | 19655.4661 | |
sql/io_cache | 1524 | 212396489184 | 139367712 | 127129271280 | 3670594224 | 22108163616 | 186617731344 | 684 | 36312146 | 53087.9327 | 620 | 36312146 | 58567.9774 | |
sql/binlog | 283 | 90837198144 | 320979384 | 23199042240 | 5945860272 | 1555804272 | 83335533600 | 66 | 860 | 13.0303 | 6 | 836 | 139.3333 | |
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 |
|