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 | 1459 | 7882429897730 | 5402624960 | 177760704150 | 1765321880 | 342898492110 | 7537766083740 | 8 | 70656 | 8832.0000 | 907 | 1076224 | 1186.5755 | |
innodb/innodb_data_file | 3518 | 5179304252750 | 1472229495 | 286952272460 | 278888638340 | 62850425770 | 4837565188640 | 1477 | 29310976 | 19844.9397 | 1461 | 56213504 | 38476.0465 | |
innodb/innodb_temp_file | 121 | 628219491880 | 5191896430 | 57388033240 | 0 | 3045329650 | 625174162230 | 0 | 0 | 0.0000 | 50 | 2195456 | 43909.1200 | |
sql/binlog | 407 | 564089353550 | 1385968815 | 29343488160 | 1723116390 | 1858216570 | 560508020590 | 82 | 924 | 11.2683 | 36 | 11338 | 314.9444 | |
sql/binlog_index | 38 | 54225259300 | 1426980480 | 31173199210 | 1373683150 | 0 | 52851576150 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 44494888070 | 808997830 | 3627172130 | 27074707090 | 0 | 17420180980 | 33 | 3381563 | 102471.6061 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1789749580 | 357949810 | 1768181230 | 1769719820 | 0 | 20029760 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 1016411210 | 127051335 | 486174300 | 773672270 | 0 | 242738940 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 856729630 | 57115185 | 791938190 | 0 | 0 | 856729630 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 11 | 826112590 | 75101000 | 531012300 | 534887130 | 0 | 291225460 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 718263420 | 179565855 | 700563010 | 702812860 | 0 | 15450560 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 285010150 | 95003295 | 270070510 | 270070510 | 0 | 14939640 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 7 | 88761220 | 12679985 | 26443290 | 0 | 0 | 88761220 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 63567670 | 21189135 | 37927860 | 0 | 22424830 | 41142840 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 7943110 | 3971555 | 7725810 | 0 | 0 | 7943110 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|