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 | 213 | 1361542964700 | 6392220290 | 177760704150 | 1765321880 | 97841817590 | 1261935825230 | 8 | 70656 | 8832.0000 | 118 | 112640 | 954.5763 | |
innodb/innodb_data_file | 1681 | 1145114679020 | 681210325 | 286952272460 | 194580236660 | 15085284000 | 935449158360 | 1216 | 25034752 | 20587.7895 | 273 | 18595840 | 68116.6300 | |
innodb/innodb_temp_file | 112 | 559354878920 | 4994239820 | 57388033240 | 0 | 2752971050 | 556601907870 | 0 | 0 | 0.0000 | 44 | 1900544 | 43194.1818 | |
sql/binlog | 131 | 104930250120 | 800994035 | 23684783100 | 1558898540 | 643700900 | 102727650680 | 28 | 708 | 25.2857 | 6 | 893 | 148.8333 | |
sql/binlog_index | 38 | 54225259300 | 1426980480 | 31173199210 | 1373683150 | 0 | 52851576150 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 35 | 29802346790 | 851495615 | 3627172130 | 17309249330 | 0 | 12493097460 | 21 | 2146437 | 102211.2857 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1789749580 | 357949810 | 1768181230 | 1769719820 | 0 | 20029760 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 856729630 | 57115185 | 791938190 | 0 | 0 | 856729630 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 634001370 | 158500210 | 486174300 | 486174300 | 0 | 147827070 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 285010150 | 95003295 | 270070510 | 270070510 | 0 | 14939640 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 2 | 227595780 | 113797890 | 218537020 | 0 | 0 | 227595780 | 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 | |
sql/misc | 4 | 52912020 | 13228005 | 26443290 | 0 | 0 | 52912020 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|