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 | 671 | 3751054075296 | 5590244352 | 66392231136 | 1322755104 | 67521802128 | 3682209518064 | 8 | 70656 | 8832.0000 | 389 | 306176 | 787.0848 | |
innodb/innodb_data_file | 2771 | 3106972879296 | 1121246016 | 203529156864 | 278462831328 | 32424683808 | 2796085364160 | 1520 | 30015488 | 19747.0316 | 819 | 35143680 | 42910.4762 | |
innodb/innodb_temp_file | 293 | 1538696125824 | 5251522584 | 32948340480 | 0 | 7096547040 | 1531599578784 | 0 | 0 | 0.0000 | 165 | 7815168 | 47364.6545 | |
sql/binlog_index | 38 | 49761668880 | 1309517352 | 33991386528 | 401265216 | 0 | 49360403664 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 503 | 49124339088 | 97662576 | 14688037056 | 5013146160 | 902575872 | 43208617056 | 122 | 1084 | 8.8852 | 4 | 343 | 85.7500 | |
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/pid | 3 | 13923888 | 4641120 | 9075264 | 0 | 4206048 | 9717840 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 2 | 13665696 | 6832848 | 10457040 | 0 | 0 | 13665696 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|