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 | 1101 | 6498914110656 | 5902737456 | 390494404608 | 1930543296 | 280818910416 | 6216164656944 | 8 | 70656 | 8832.0000 | 692 | 1061376 | 1533.7803 | |
innodb/innodb_data_file | 2670 | 4509334651536 | 1688889312 | 224988546816 | 232999832736 | 68680865616 | 4207653953184 | 1220 | 25100288 | 20574.0066 | 963 | 41074688 | 42652.8432 | |
innodb/innodb_temp_file | 105 | 462004475328 | 4400042592 | 41453083056 | 0 | 2589868512 | 459414606816 | 0 | 0 | 0.0000 | 41 | 1589248 | 38762.1463 | |
sql/binlog | 278 | 437153813712 | 1572495672 | 31319099328 | 833786976 | 1713941856 | 434606084880 | 54 | 959 | 17.7593 | 29 | 9365 | 322.9310 | |
sql/binlog_index | 38 | 51802032480 | 1363211256 | 32058328368 | 378331008 | 0 | 51423701472 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 40 | 31228781760 | 780719544 | 3428419104 | 17658924624 | 0 | 13569857136 | 24 | 2450338 | 102097.4167 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 3292047264 | 658409400 | 3275252112 | 3276422160 | 0 | 15625104 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 2115607296 | 528901824 | 2084164896 | 0 | 0 | 2115607296 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 60 | 1613301888 | 26888136 | 600916800 | 84691728 | 609958800 | 918651360 | 16 | 1115648 | 69728.0000 | 24 | 1098152 | 45756.3333 | |
sql/casetest | 15 | 879414624 | 58627536 | 812650080 | 0 | 0 | 879414624 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 280023744 | 93341160 | 261075936 | 261075936 | 0 | 18947808 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 46465584 | 15488352 | 36759888 | 0 | 7066752 | 39398832 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|