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 | 1804 | 10607808811776 | 5880159912 | 886357028832 | 1090735536 | 301500674112 | 10305217402128 | 8 | 70656 | 8832.0000 | 1070 | 895488 | 836.9047 | |
innodb/innodb_data_file | 4459 | 5623075919472 | 1261062000 | 255052925424 | 340667353488 | 57295913664 | 5225112652320 | 1607 | 31440896 | 19564.9633 | 2146 | 77348864 | 36043.2731 | |
innodb/innodb_temp_file | 564 | 1069715472672 | 1896658632 | 46263986208 | 0 | 64130664576 | 1005584808096 | 0 | 0 | 0.0000 | 474 | 10387456 | 21914.4641 | |
sql/io_cache | 244 | 197039290800 | 807537984 | 95848039584 | 553280640 | 7583848272 | 188902161888 | 118 | 5736484 | 48614.2712 | 96 | 5736484 | 59755.0417 | |
sql/binlog | 623 | 164368901664 | 263834472 | 38410694256 | 1517132496 | 10055396208 | 152796372960 | 150 | 1196 | 7.9733 | 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 |
|