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 | 1829 | 10741555367664 | 5872911528 | 886357028832 | 1090735536 | 301679773824 | 10438784858304 | 8 | 70656 | 8832.0000 | 1084 | 902656 | 832.7085 | |
innodb/innodb_data_file | 4491 | 5713505582400 | 1272212304 | 255052925424 | 343400671152 | 57531139248 | 5312573772000 | 1612 | 31522816 | 19555.0968 | 2161 | 77774848 | 35990.2119 | |
innodb/innodb_temp_file | 571 | 1098261381888 | 1923399720 | 46263986208 | 0 | 64291096320 | 1033970285568 | 0 | 0 | 0.0000 | 479 | 10600448 | 22130.3716 | |
sql/io_cache | 244 | 197039290800 | 807537984 | 95848039584 | 553280640 | 7583848272 | 188902161888 | 118 | 5736484 | 48614.2712 | 96 | 5736484 | 59755.0417 | |
sql/binlog | 647 | 164498131776 | 254247312 | 38410694256 | 1535302560 | 10055396208 | 152907433008 | 156 | 1220 | 7.8205 | 8 | 1723 | 215.3750 | |
sql/binlog_index | 38 | 44217743328 | 1163624616 | 24694093248 | 228775008 | 0 | 43988968320 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 75 | 42652464624 | 568699296 | 3930899808 | 21180094848 | 0 | 21472369776 | 45 | 4608225 | 102405.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 3121 | 4393841232 | 1407648 | 1940612256 | 4147895136 | 0 | 245946096 | 2102 | 126070 | 59.9762 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 4205834160 | 525729072 | 2253383088 | 1788136944 | 0 | 2417697216 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 16 | 3225784320 | 201611520 | 1540870848 | 3152224944 | 0 | 73559376 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
csv/data | 11 | 2083031280 | 189366408 | 2022837696 | 2030941440 | 0 | 52089840 | 3 | 0 | 0.0000 | 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 | |
sql/misc | 3 | 37599936 | 12533136 | 13226928 | 0 | 0 | 37599936 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|