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 | 3229 | 16605164196192 | 5142509592 | 65532520416 | 1130456448 | 394567011696 | 16209466728048 | 8 | 70656 | 8832.0000 | 1945 | 1561088 | 802.6159 | |
innodb/innodb_data_file | 6260 | 7491781611600 | 1196770080 | 247930575552 | 288246022944 | 98743059888 | 7104792528768 | 1520 | 30015488 | 19747.0316 | 3890 | 132562944 | 34077.8776 | |
innodb/innodb_temp_file | 159 | 811701345312 | 5105039808 | 45979492416 | 0 | 3385498512 | 808315846800 | 0 | 0 | 0.0000 | 76 | 3407872 | 44840.4211 | |
sql/binlog | 429 | 266416454832 | 621017232 | 24593866704 | 848183424 | 1087451904 | 264480819504 | 97 | 984 | 10.1443 | 17 | 4378 | 257.5294 | |
sql/binlog_index | 38 | 52603265616 | 1384296408 | 31193349792 | 1554924624 | 0 | 51048340992 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 39592728384 | 609118752 | 2470122864 | 21878738112 | 0 | 17713990272 | 39 | 3998232 | 102518.7692 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 4442192832 | 555274104 | 2014340064 | 2266602624 | 0 | 2175590208 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/misc | 10 | 2431692384 | 243169080 | 2272814016 | 0 | 0 | 2431692384 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 561 | 2257384800 | 4023624 | 1403158416 | 2201886192 | 0 | 55498608 | 550 | 36850 | 67.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 12 | 1037919168 | 86493264 | 498455760 | 987618720 | 0 | 50300448 | 6 | 1261 | 210.1667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 746135808 | 49742352 | 672702624 | 0 | 0 | 746135808 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 506447568 | 101289408 | 487699872 | 488841936 | 0 | 17605632 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 377332032 | 125777256 | 342909600 | 342909600 | 0 | 34422432 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 76565280 | 19141320 | 52562928 | 0 | 0 | 76565280 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 15114528 | 5038176 | 12309792 | 0 | 2111472 | 13003056 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|