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 | 2309 | 11923206460704 | 5163796440 | 65532520416 | 1130456448 | 257218139904 | 11664857864352 | 8 | 70656 | 8832.0000 | 1392 | 1141760 | 820.2299 | |
innodb/innodb_data_file | 5006 | 5508932423808 | 1100465784 | 247930575552 | 267149268672 | 74296063248 | 5167487091888 | 1466 | 29130752 | 19870.9086 | 2906 | 101793792 | 35028.8341 | |
innodb/innodb_temp_file | 141 | 696436541856 | 4939266024 | 45979492416 | 0 | 2872667424 | 693563874432 | 0 | 0 | 0.0000 | 64 | 2818048 | 44032.0000 | |
sql/binlog | 313 | 167498608464 | 535139088 | 21508836096 | 776967312 | 995321184 | 165726319968 | 71 | 880 | 12.3944 | 11 | 2632 | 239.2727 | |
sql/binlog_index | 38 | 52603265616 | 1384296408 | 31193349792 | 1554924624 | 0 | 51048340992 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 36014224224 | 600237000 | 2470122864 | 18956415456 | 0 | 17057808768 | 36 | 3691685 | 102546.8056 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 4442192832 | 555274104 | 2014340064 | 2266602624 | 0 | 2175590208 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 560 | 2248837536 | 4015704 | 1403158416 | 2201886192 | 0 | 46951344 | 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 | |
sql/misc | 6 | 118829568 | 19804752 | 29251200 | 0 | 0 | 118829568 | 0 | 0 | 0.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 |
|