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 | 431 | 2406792237168 | 5584204560 | 37645276416 | 1191303696 | 98067982320 | 2307532951152 | 8 | 70656 | 8832.0000 | 243 | 236544 | 973.4321 | |
innodb/innodb_data_file | 2235 | 2044519339632 | 914773728 | 169423363824 | 161746937616 | 30022608000 | 1852749794016 | 1300 | 26411008 | 20316.1600 | 627 | 29573120 | 47166.0606 | |
innodb/innodb_temp_file | 116 | 518756646144 | 4472039880 | 37804350672 | 0 | 1531534224 | 517225111920 | 0 | 0 | 0.0000 | 47 | 2015232 | 42877.2766 | |
sql/binlog | 277 | 80171932368 | 289429272 | 21348228000 | 901990320 | 9004965024 | 70264977024 | 65 | 856 | 13.1692 | 5 | 828 | 165.6000 | |
sql/binlog_index | 38 | 56840692128 | 1495807632 | 32797782336 | 235184928 | 0 | 56605507200 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 30891870240 | 617837352 | 3923871600 | 17530141728 | 0 | 13361728512 | 30 | 3064643 | 102154.7667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 8668866624 | 1083608328 | 4681248000 | 5365219200 | 0 | 3303647424 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 778904016 | 51926688 | 709585008 | 0 | 0 | 778904016 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 570179280 | 114035856 | 552368784 | 553647072 | 0 | 16532208 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 4 | 329673168 | 82418160 | 227912784 | 0 | 0 | 329673168 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 273319728 | 91106400 | 259132896 | 259132896 | 0 | 14186832 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 2 | 14781888 | 7390944 | 11500896 | 0 | 0 | 14781888 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 12757008 | 4252248 | 10295472 | 0 | 1823712 | 10933296 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|