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 | 411 | 2653382844816 | 6455919096 | 429268256208 | 1762230096 | 70144739808 | 2581475874912 | 8 | 70656 | 8832.0000 | 241 | 240640 | 998.5062 | |
innodb/innodb_data_file | 2035 | 2330217169104 | 1145069640 | 454573190016 | 741555526800 | 44800298400 | 1543861343904 | 1365 | 27475968 | 20128.9143 | 386 | 22233088 | 57598.6736 | |
innodb/innodb_temp_file | 104 | 461428644336 | 4436813832 | 34405054992 | 0 | 2763467520 | 458665176816 | 0 | 0 | 0.0000 | 40 | 1572864 | 39321.6000 | |
sql/binlog | 155 | 273014528688 | 1761383976 | 19993338816 | 2703087024 | 1852542384 | 268458899280 | 26 | 700 | 26.9231 | 22 | 5938 | 269.9091 | |
sql/binlog_index | 38 | 46739872080 | 1229996592 | 28217923008 | 726771408 | 0 | 46013100672 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 35 | 37569132480 | 1073403672 | 6313648176 | 20940965760 | 0 | 16628166720 | 21 | 2155209 | 102629.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 2378109888 | 594527472 | 2279011152 | 2287963920 | 0 | 90145968 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1348322976 | 269664384 | 1329540960 | 1331123904 | 0 | 17199072 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 846022848 | 56401488 | 780393504 | 0 | 0 | 846022848 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 260205264 | 86735088 | 245562240 | 245562240 | 0 | 14643024 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 53416176 | 17805216 | 27231600 | 0 | 0 | 53416176 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 41869872 | 13956624 | 32558592 | 0 | 6942144 | 34927728 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 33815760 | 16907880 | 32606112 | 0 | 0 | 33815760 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|