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 | 233 | 1358989557024 | 5832573120 | 45126181056 | 1244144352 | 23866603728 | 1333878808944 | 8 | 70656 | 8832.0000 | 131 | 118272 | 902.8397 | |
innodb/innodb_data_file | 1724 | 1194149199936 | 692661816 | 234607045728 | 230890884576 | 20409190560 | 942849124800 | 1231 | 25280512 | 20536.5654 | 283 | 18923520 | 66867.5618 | |
innodb/innodb_temp_file | 96 | 390267829776 | 4065289800 | 24588505920 | 0 | 2240535792 | 388027293984 | 0 | 0 | 0.0000 | 34 | 1343488 | 39514.3529 | |
sql/binlog | 201 | 84776362176 | 421772736 | 25074991920 | 1358413584 | 1302850560 | 82115098032 | 46 | 780 | 16.9565 | 5 | 585 | 117.0000 | |
sql/binlog_index | 38 | 52962765504 | 1393756848 | 35198799504 | 1198335600 | 0 | 51764429904 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 40 | 25194986784 | 629874432 | 2400623280 | 11454425136 | 0 | 13740561648 | 24 | 2460736 | 102530.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 930731472 | 62048712 | 871372128 | 0 | 0 | 930731472 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 530502720 | 106100544 | 509990448 | 511301472 | 0 | 19201248 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 361902288 | 120634008 | 328947696 | 328947696 | 0 | 32954592 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 252986448 | 84328728 | 221968560 | 0 | 0 | 252986448 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 19363872 | 6454536 | 15878544 | 0 | 2616768 | 16747104 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|