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 | 464 | 2503631282592 | 5395756872 | 53411284608 | 1090735536 | 58199991696 | 2444340555360 | 8 | 70656 | 8832.0000 | 267 | 236544 | 885.9326 | |
innodb/innodb_data_file | 2200 | 1794197947344 | 815544312 | 255052925424 | 263843740512 | 23779136832 | 1506575070000 | 1327 | 26853376 | 20236.1537 | 573 | 28065792 | 48980.4398 | |
innodb/innodb_temp_file | 296 | 618707799072 | 2090228976 | 33271808064 | 0 | 7837828416 | 610869970656 | 0 | 0 | 0.0000 | 226 | 5013504 | 22183.6460 | |
sql/binlog_index | 38 | 44217743328 | 1163624616 | 24694093248 | 228775008 | 0 | 43988968320 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 173 | 42177258816 | 243798984 | 19495037232 | 907692720 | 76851456 | 41192714640 | 40 | 756 | 18.9000 | 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/dfile | 32 | 1062923136 | 33216216 | 771527328 | 1042588800 | 0 | 20334336 | 26 | 1936 | 74.4615 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 993242448 | 124155240 | 643010544 | 964287984 | 0 | 28954464 | 4 | 854 | 213.5000 | 0 | 0 | 0.0000 | |
sql/io_cache | 46 | 984453888 | 21401160 | 90200880 | 98560704 | 592346832 | 293546352 | 16 | 1113480 | 69592.5000 | 20 | 1113480 | 55674.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 |
|