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 | 668 | 4450900487088 | 6663024456 | 886357028832 | 1090735536 | 83659006464 | 4366150745088 | 8 | 70656 | 8832.0000 | 388 | 327680 | 844.5361 | |
innodb/innodb_data_file | 2747 | 2578705660080 | 938735160 | 255052925424 | 296765664096 | 30124884240 | 2251815111744 | 1513 | 29900800 | 19762.5909 | 829 | 36061184 | 43499.6188 | |
innodb/innodb_temp_file | 339 | 751188838752 | 2215896144 | 46263986208 | 0 | 61930703472 | 689258135280 | 0 | 0 | 0.0000 | 266 | 5865472 | 22050.6466 | |
sql/io_cache | 140 | 94389085824 | 674207688 | 92002618752 | 296558592 | 1472731920 | 92619795312 | 64 | 3257960 | 50905.6250 | 56 | 3257960 | 58177.8571 | |
sql/binlog_index | 38 | 44217743328 | 1163624616 | 24694093248 | 228775008 | 0 | 43988968320 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 205 | 42644571024 | 208022232 | 19495037232 | 1193004384 | 76851456 | 41374715184 | 48 | 788 | 16.4167 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 60 | 35671948752 | 594532224 | 3930899808 | 18037972656 | 0 | 17633976096 | 36 | 3694649 | 102629.1389 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 4205834160 | 525729072 | 2253383088 | 1788136944 | 0 | 2417697216 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 12 | 1655208720 | 137933928 | 644688000 | 1610470752 | 0 | 44737968 | 6 | 1296 | 216.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 34 | 1072532736 | 31544832 | 771527328 | 1042588800 | 0 | 29943936 | 26 | 1936 | 74.4615 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 779265696 | 51950976 | 715726704 | 0 | 0 | 779265696 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 708786672 | 141757176 | 688565328 | 690146160 | 0 | 18640512 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 290792832 | 96930768 | 274138128 | 274138128 | 0 | 16654704 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 54821712 | 18273816 | 35330064 | 0 | 16422912 | 38398800 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
csv/data | 6 | 38337024 | 6389328 | 13111296 | 5442624 | 0 | 32894400 | 1 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 1 | 13226928 | 13226928 | 13226928 | 0 | 0 | 13226928 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|