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 | 346 | 2079144619200 | 6009088272 | 120498945072 | 1276522896 | 80825836080 | 1997042260224 | 8 | 70656 | 8832.0000 | 197 | 182784 | 927.8376 | |
innodb/innodb_data_file | 2241 | 2020283471712 | 901509576 | 217777853568 | 238933865280 | 31367399712 | 1749982206720 | 1402 | 28082176 | 20030.0827 | 539 | 26787840 | 49699.1466 | |
innodb/innodb_temp_file | 107 | 427721731536 | 3997399296 | 34228008672 | 0 | 27590869680 | 400130861856 | 0 | 0 | 0.0000 | 44 | 1572864 | 35746.9091 | |
sql/binlog_index | 38 | 43713249888 | 1150348584 | 26208677088 | 1778742768 | 0 | 41934507120 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 151 | 43402568352 | 287434224 | 15325936032 | 919353600 | 602692992 | 41880521760 | 34 | 732 | 21.5294 | 4 | 353 | 88.2500 | |
sql/ERRMSG | 40 | 33828267264 | 845706576 | 7864958112 | 13719616944 | 0 | 20108650320 | 24 | 2454613 | 102275.5417 | 0 | 0 | 0.0000 | |
sql/io_cache | 76 | 3899688672 | 51311568 | 1965043872 | 167710224 | 1377114288 | 2354864160 | 32 | 1987768 | 62117.7500 | 34 | 1987768 | 58463.7647 | |
mysys/cnf | 5 | 1688832288 | 337766352 | 1671788448 | 1672950048 | 0 | 15882240 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 955998384 | 63733032 | 892974720 | 0 | 0 | 955998384 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 346453536 | 115484424 | 331441968 | 331441968 | 0 | 15011568 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 328577040 | 82144128 | 309072720 | 310528416 | 0 | 18048624 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 2 | 21828048 | 10914024 | 18759312 | 0 | 0 | 21828048 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 2 | 20617344 | 10308672 | 15505248 | 0 | 0 | 20617344 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 12477696 | 4159056 | 10180368 | 0 | 1769856 | 10707840 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|