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 | 746 | 3761260300512 | 5041903680 | 209824854624 | 812020704 | 108773042400 | 3651675237408 | 8 | 70656 | 8832.0000 | 471 | 713216 | 1514.2590 | |
innodb/innodb_data_file | 2173 | 1771192852704 | 815091024 | 174330162336 | 167446528128 | 30160253376 | 1573586071200 | 1268 | 23871488 | 18826.0946 | 662 | 31473664 | 47543.2991 | |
innodb/innodb_temp_file | 122 | 527561519232 | 4324274592 | 31946089296 | 0 | 2335081056 | 525226438176 | 0 | 0 | 0.0000 | 52 | 2162688 | 41590.1538 | |
sql/binlog | 293 | 204763148304 | 698850240 | 19841859312 | 7050194976 | 1263800736 | 196449152592 | 74 | 123075 | 1663.1757 | 16 | 6894 | 430.8750 | |
sql/ERRMSG | 40 | 27808739376 | 695218392 | 4180529760 | 12463893024 | 0 | 15344846352 | 24 | 2459703 | 102487.6250 | 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 |
|