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_data_file | 1799 | 1657646712480 | 921426528 | 194651863824 | 173427827760 | 17883742800 | 1466335141920 | 1218 | 25067520 | 20580.8867 | 317 | 19578880 | 61763.0284 | |
innodb/innodb_log_file | 254 | 1387834112016 | 5463913752 | 48523293456 | 1344332880 | 26792167776 | 1359697611360 | 8 | 70656 | 8832.0000 | 139 | 123392 | 887.7122 | |
innodb/innodb_temp_file | 369 | 1116553240704 | 3025889328 | 451593983280 | 0 | 549188217072 | 567365023632 | 0 | 0 | 0.0000 | 297 | 6307840 | 21238.5185 | |
sql/binlog | 173 | 66146409648 | 382349088 | 18450737712 | 934525680 | 2806776192 | 62405107776 | 39 | 752 | 19.2821 | 5 | 644 | 128.8000 | |
sql/binlog_index | 38 | 56345363184 | 1482772632 | 28685321808 | 184998000 | 0 | 56160365184 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 40 | 16338647424 | 408466080 | 1855062528 | 10394880144 | 0 | 5943767280 | 24 | 2451963 | 102165.1250 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1218536352 | 243707112 | 1191844896 | 1193067216 | 0 | 25469136 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 736376784 | 49091592 | 659538000 | 0 | 0 | 736376784 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 182082384 | 60694128 | 168645840 | 168645840 | 0 | 13436544 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 31372704 | 10457568 | 18168480 | 0 | 0 | 31372704 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 15901248 | 5300328 | 10242672 | 0 | 4984320 | 10916928 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|