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 | 352 | 2711696256720 | 7703682360 | 702658584144 | 1459148592 | 103475222928 | 2606761885200 | 8 | 70656 | 8832.0000 | 195 | 199168 | 1021.3744 | |
innodb/innodb_data_file | 2117 | 2030994827136 | 959373888 | 260410094208 | 249620416848 | 25724312064 | 1755650098224 | 1291 | 26263552 | 20343.5724 | 529 | 26460160 | 50019.2060 | |
innodb/innodb_temp_file | 105 | 464543640000 | 4424224992 | 30940605168 | 0 | 3641666688 | 460901973312 | 0 | 0 | 0.0000 | 41 | 1589248 | 38762.1463 | |
sql/binlog | 259 | 78103793856 | 301559016 | 18991388064 | 816392016 | 826938816 | 76460463024 | 60 | 836 | 13.9333 | 6 | 1124 | 187.3333 | |
sql/binlog_index | 38 | 53134159056 | 1398267288 | 30405174096 | 581688624 | 0 | 52552470432 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 50 | 35743061376 | 714861048 | 2740245024 | 19891246848 | 0 | 15851814528 | 30 | 3078053 | 102601.7667 | 0 | 0 | 0.0000 | |
sql/io_cache | 128 | 4874140656 | 38079096 | 1956218880 | 491529984 | 1475035584 | 2907575088 | 48 | 2674520 | 55719.1667 | 50 | 2657024 | 53140.4800 | |
sql/casetest | 15 | 756694224 | 50446176 | 691358976 | 0 | 0 | 756694224 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 620978688 | 124195632 | 585911040 | 599333856 | 0 | 21644832 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 266793648 | 88931040 | 254642784 | 254642784 | 0 | 12150864 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 199019040 | 66339504 | 174205680 | 0 | 0 | 199019040 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 48508416 | 16169472 | 38550336 | 0 | 7343424 | 41164992 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|