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 | 952 | 5985229315824 | 6287005560 | 886357028832 | 1090735536 | 122212216896 | 5861926363392 | 8 | 70656 | 8832.0000 | 557 | 449024 | 806.1472 | |
innodb/innodb_data_file | 3175 | 3380068435920 | 1064588448 | 255052925424 | 309271046832 | 35146432992 | 3035650956096 | 1532 | 30212096 | 19720.6893 | 1157 | 46219264 | 39947.5056 | |
innodb/innodb_temp_file | 447 | 862041889104 | 1928505216 | 46263986208 | 0 | 62944688400 | 799097200704 | 0 | 0 | 0.0000 | 367 | 7979008 | 21741.1662 | |
sql/io_cache | 140 | 94389085824 | 674207688 | 92002618752 | 296558592 | 1472731920 | 92619795312 | 64 | 3257960 | 50905.6250 | 56 | 3257960 | 58177.8571 | |
sql/binlog | 355 | 91799779632 | 258590904 | 38410694256 | 1303667376 | 9986386608 | 80509725648 | 85 | 936 | 11.0118 | 4 | 403 | 100.7500 | |
sql/binlog_index | 38 | 44217743328 | 1163624616 | 24694093248 | 228775008 | 0 | 43988968320 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 70 | 40301046720 | 575729088 | 3930899808 | 20270352432 | 0 | 20030694288 | 42 | 4303959 | 102475.2143 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 4205834160 | 525729072 | 2253383088 | 1788136944 | 0 | 2417697216 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 3038 | 2069274240 | 681120 | 771527328 | 1898390736 | 0 | 170883504 | 2026 | 120784 | 59.6170 | 0 | 0 | 0.0000 | |
myisam/kfile | 12 | 1655208720 | 137933928 | 644688000 | 1610470752 | 0 | 44737968 | 6 | 1296 | 216.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 | |
csv/data | 6 | 38337024 | 6389328 | 13111296 | 5442624 | 0 | 32894400 | 1 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 2 | 25252656 | 12626328 | 13226928 | 0 | 0 | 25252656 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|