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 | 1531 | 624631802784 | 407989296 | 174330162336 | 135900619536 | 11549541168 | 477181642080 | 1224 | 23150592 | 18913.8824 | 210 | 16662528 | 79345.3714 | |
innodb/innodb_log_file | 100 | 474374860080 | 4743748416 | 23480494224 | 812020704 | 3699977952 | 469862861424 | 8 | 70656 | 8832.0000 | 51 | 80384 | 1576.1569 | |
innodb/innodb_temp_file | 108 | 445220208576 | 4122409104 | 31946089296 | 0 | 1955734176 | 443264474400 | 0 | 0 | 0.0000 | 43 | 1687552 | 39245.3953 | |
sql/binlog | 127 | 59466790416 | 468242280 | 16251955104 | 4974953280 | 550472736 | 53941364400 | 38 | 122931 | 3235.0263 | 5 | 641 | 128.2000 | |
sql/ERRMSG | 35 | 25709407680 | 734554392 | 4180529760 | 11372085648 | 0 | 14337322032 | 21 | 2140921 | 101948.6190 | 0 | 0 | 0.0000 | |
sql/io_cache | 23 | 7711309056 | 335274192 | 6757732080 | 63900672 | 747648528 | 6899759856 | 8 | 558802 | 69850.2500 | 10 | 558802 | 55880.2000 | |
sql/binlog_index | 23 | 1051106496 | 45700248 | 324180384 | 774902832 | 0 | 276203664 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 847395648 | 56492832 | 771293424 | 0 | 0 | 847395648 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 244363680 | 81454560 | 227170416 | 227170416 | 0 | 17193264 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 242400576 | 48479904 | 224960736 | 226088016 | 0 | 16312560 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 46027872 | 15342624 | 27984528 | 0 | 15493632 | 30534240 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 3 | 31061184 | 10353552 | 11944944 | 0 | 0 | 31061184 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|