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 | 819 | 4704429022128 | 5744113320 | 66392231136 | 1322755104 | 97821526704 | 4605284740320 | 8 | 70656 | 8832.0000 | 476 | 410112 | 861.5798 | |
innodb/innodb_data_file | 2997 | 4094432170752 | 1366176768 | 203529156864 | 280413931776 | 39573497040 | 3774444741936 | 1523 | 30064640 | 19740.4071 | 973 | 39862272 | 40968.4193 | |
innodb/innodb_temp_file | 371 | 2060138072784 | 5552932704 | 37632325104 | 0 | 9917949360 | 2050220123424 | 0 | 0 | 0.0000 | 218 | 10321920 | 47348.2569 | |
sql/binlog | 667 | 107933943744 | 161819856 | 16679138784 | 5128477728 | 980827056 | 101824638960 | 161 | 1240 | 7.7019 | 8 | 1479 | 184.8750 | |
sql/binlog_index | 38 | 49761668880 | 1309517352 | 33991386528 | 401265216 | 0 | 49360403664 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 32867803056 | 505658472 | 3329219520 | 22476917232 | 0 | 10390885824 | 39 | 3992068 | 102360.7179 | 0 | 0 | 0.0000 | |
myisam/kfile | 12 | 7074023088 | 589501704 | 6122097696 | 7014693312 | 0 | 59329776 | 6 | 1241 | 206.8333 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1541178672 | 308235576 | 1522170144 | 1523355504 | 0 | 17823168 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 840816240 | 56054328 | 764598384 | 0 | 0 | 840816240 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 37 | 810781488 | 21912792 | 370214064 | 725102928 | 0 | 85678560 | 26 | 1042 | 40.0769 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 440951280 | 110237688 | 297882816 | 297882816 | 0 | 143068464 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 8 | 344914416 | 43114104 | 313535904 | 15315168 | 0 | 329599248 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 248837952 | 82945896 | 229745472 | 229745472 | 0 | 19092480 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 36175392 | 9043848 | 11942832 | 0 | 0 | 36175392 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13923888 | 4641120 | 9075264 | 0 | 4206048 | 9717840 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|