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 | 181 | 1071040800192 | 5917352232 | 114949024608 | 1432685232 | 70137452880 | 999470662080 | 8 | 70656 | 8832.0000 | 105 | 105984 | 1009.3714 | |
innodb/innodb_data_file | 1623 | 616722080304 | 379988928 | 219869346576 | 166961694768 | 21155593536 | 428604792000 | 1195 | 24690688 | 20661.6636 | 251 | 18137088 | 72259.3147 | |
innodb/innodb_temp_file | 97 | 444341075376 | 4580835600 | 37375926720 | 0 | 862408800 | 443478666576 | 0 | 0 | 0.0000 | 34 | 1409024 | 41441.8824 | |
sql/binlog_index | 38 | 45986038560 | 1210158840 | 29645548944 | 579655824 | 0 | 45406382736 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 45 | 31307005488 | 695711016 | 15568182960 | 434724576 | 46778688 | 30825502224 | 8 | 628 | 78.5000 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 20 | 23846100960 | 1192305048 | 7904142576 | 9923866656 | 0 | 13922234304 | 12 | 1218390 | 101532.5000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1803762048 | 360752304 | 1767272496 | 1768633152 | 0 | 35128896 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 857192688 | 57145968 | 777431424 | 0 | 0 | 857192688 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 311792448 | 103930728 | 279432912 | 279432912 | 0 | 32359536 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 17499504 | 5833080 | 13821456 | 0 | 2626800 | 14872704 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 5423088 | 5423088 | 5423088 | 0 | 0 | 5423088 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|