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 | 655 | 3223119078960 | 4920792360 | 209824854624 | 812020704 | 96837141984 | 3125469916272 | 8 | 70656 | 8832.0000 | 419 | 678400 | 1619.0931 | |
innodb/innodb_data_file | 2101 | 1622240256912 | 772127664 | 174330162336 | 162573798816 | 29330167152 | 1430336290944 | 1263 | 23789568 | 18835.7625 | 612 | 29966336 | 48964.6013 | |
innodb/innodb_temp_file | 119 | 513590931744 | 4315889952 | 31946089296 | 0 | 2269377792 | 511321553952 | 0 | 0 | 0.0000 | 50 | 2064384 | 41287.6800 | |
sql/binlog | 205 | 204464113392 | 997385664 | 19841859312 | 7008005664 | 1263800736 | 196192306992 | 52 | 122987 | 2365.1346 | 16 | 6894 | 430.8750 | |
sql/ERRMSG | 35 | 25709407680 | 734554392 | 4180529760 | 11372085648 | 0 | 14337322032 | 21 | 2140921 | 101948.6190 | 0 | 0 | 0.0000 | |
sql/io_cache | 73 | 9219607584 | 126295752 | 6757732080 | 195959280 | 1737561936 | 7286086368 | 26 | 1870234 | 71932.0769 | 32 | 1870234 | 58444.8125 | |
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 |
|