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 | 1012 | 5272911976660 | 5210387070 | 177760704150 | 1765321880 | 299161934400 | 4971984720380 | 8 | 70656 | 8832.0000 | 642 | 822784 | 1281.5950 | |
innodb/innodb_data_file | 2550 | 3338273541190 | 1309126765 | 286952272460 | 223584515810 | 48300720020 | 3066388305360 | 1282 | 26116096 | 20371.3697 | 884 | 38354944 | 43387.9457 | |
innodb/innodb_temp_file | 115 | 575837843940 | 5007285505 | 57388033240 | 0 | 2831673400 | 573006170540 | 0 | 0 | 0.0000 | 46 | 1998848 | 43453.2174 | |
sql/binlog | 207 | 500983618300 | 2420210550 | 29343488160 | 1576919070 | 1258563440 | 498148135790 | 34 | 732 | 21.5294 | 32 | 10207 | 318.9688 | |
sql/binlog_index | 38 | 54225259300 | 1426980480 | 31173199210 | 1373683150 | 0 | 52851576150 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 40 | 36858616270 | 921465155 | 3627172130 | 21148909060 | 0 | 15709707210 | 24 | 2457390 | 102391.2500 | 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 | |
mysys/charset | 3 | 285010150 | 95003295 | 270070510 | 270070510 | 0 | 14939640 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 269818760 | 67454690 | 218537020 | 0 | 0 | 269818760 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 5 | 65631490 | 13126245 | 26443290 | 0 | 0 | 65631490 | 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 |
|