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 | 760 | 4332453422880 | 5700596352 | 66392231136 | 1322755104 | 89885082144 | 4241245585632 | 8 | 70656 | 8832.0000 | 441 | 366592 | 831.2744 | |
innodb/innodb_data_file | 2896 | 3744043091712 | 1292832552 | 203529156864 | 278478640176 | 38098740240 | 3427465711296 | 1522 | 30048256 | 19742.6124 | 903 | 37666816 | 41712.9745 | |
innodb/innodb_temp_file | 350 | 1920625980240 | 5487502680 | 37632325104 | 0 | 9206133552 | 1911419846688 | 0 | 0 | 0.0000 | 204 | 9633792 | 47224.4706 | |
sql/binlog | 589 | 90821110512 | 154195272 | 16345385232 | 5072468016 | 943934112 | 84804708384 | 142 | 1164 | 8.1972 | 7 | 1074 | 153.4286 | |
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 |
|