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 | 213 | 936055718928 | 4394627688 | 28523828784 | 1300219536 | 16348182576 | 918407316816 | 8 | 70656 | 8832.0000 | 119 | 120832 | 1015.3950 | |
innodb/innodb_data_file | 1706 | 825095063232 | 483642984 | 216499813728 | 200362185936 | 9473671152 | 615259206144 | 1266 | 25853952 | 20421.7630 | 270 | 18661376 | 69116.2074 | |
innodb/innodb_temp_file | 98 | 331685890272 | 3384549696 | 29902855488 | 0 | 782927376 | 330902962896 | 0 | 0 | 0.0000 | 37 | 1327104 | 35867.6757 | |
sql/binlog | 71 | 58408389600 | 822653304 | 28360815648 | 477972000 | 291020928 | 57639396672 | 14 | 652 | 46.5714 | 4 | 344 | 86.0000 | |
sql/binlog_index | 38 | 53304932208 | 1402761360 | 26011206144 | 1466168880 | 0 | 51838763328 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 25 | 11803419936 | 472136544 | 3179521488 | 4679002416 | 0 | 7124417520 | 15 | 1529101 | 101940.0667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 778753008 | 51916656 | 711011664 | 0 | 0 | 778753008 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 678259824 | 84782280 | 331370160 | 551470128 | 0 | 126789696 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 491764944 | 98352936 | 472421136 | 473838816 | 0 | 17926128 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 332935152 | 110978208 | 316179600 | 316179600 | 0 | 16755552 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 236966928 | 59241600 | 202751472 | 0 | 0 | 236966928 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 2 | 15674736 | 7837368 | 12048960 | 0 | 0 | 15674736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13805616 | 4601784 | 9489744 | 0 | 3655872 | 10149744 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|