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 | 666 | 3293535150048 | 4945247736 | 209824854624 | 812020704 | 96927072000 | 3195796057344 | 8 | 70656 | 8832.0000 | 425 | 681472 | 1603.4635 | |
innodb/innodb_data_file | 2105 | 1651435337376 | 784529592 | 174330162336 | 162573798816 | 29387158416 | 1459474380144 | 1263 | 23789568 | 18835.7625 | 614 | 29999104 | 48858.4756 | |
innodb/innodb_temp_file | 119 | 513590931744 | 4315889952 | 31946089296 | 0 | 2269377792 | 511321553952 | 0 | 0 | 0.0000 | 50 | 2064384 | 41287.6800 | |
sql/binlog | 213 | 204496382640 | 960076656 | 19841859312 | 7012863792 | 1263800736 | 196219718112 | 54 | 122995 | 2277.6852 | 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 |
|