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 | 1138 | 6379570867296 | 5605949712 | 111088269072 | 1529397936 | 229123250400 | 6148918218960 | 8 | 70656 | 8832.0000 | 673 | 571904 | 849.7831 | |
innodb/innodb_data_file | 3219 | 4139054170944 | 1285819656 | 223074797616 | 271497622176 | 42037533120 | 3825519015648 | 1330 | 26902528 | 20227.4647 | 1443 | 55164928 | 38229.3333 | |
innodb/innodb_temp_file | 255 | 1309189136112 | 5134074792 | 54622378800 | 0 | 61391291280 | 1247797844832 | 0 | 0 | 0.0000 | 151 | 6012928 | 39820.7152 | |
sql/binlog | 415 | 229048967136 | 551925000 | 23757151440 | 637837200 | 1771242000 | 226639887936 | 94 | 972 | 10.3404 | 16 | 3431 | 214.4375 | |
sql/binlog_index | 38 | 49367233872 | 1299137664 | 25897829760 | 542698992 | 0 | 48824534880 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 30612479040 | 556590408 | 2116245648 | 16448880096 | 0 | 14163598944 | 33 | 3381351 | 102465.1818 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1626003984 | 325200744 | 1601333712 | 1603475280 | 0 | 22528704 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 965857200 | 64390392 | 901338240 | 0 | 0 | 965857200 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 939061728 | 117382584 | 529160016 | 729897696 | 0 | 209164032 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 295831536 | 73957752 | 255767952 | 0 | 0 | 295831536 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 234933072 | 78310848 | 221570976 | 221570976 | 0 | 13362096 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 8 | 120546624 | 15068328 | 21667008 | 0 | 0 | 120546624 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 47110272 | 15703248 | 36738768 | 0 | 7673952 | 39436320 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|