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 | 365 | 2811576402624 | 7702948968 | 702658584144 | 1459148592 | 103691674944 | 2706425579088 | 8 | 70656 | 8832.0000 | 202 | 202752 | 1003.7228 | |
innodb/innodb_data_file | 2129 | 2114459657376 | 993170112 | 260410094208 | 249620416848 | 25986988896 | 1838852251632 | 1291 | 26263552 | 20343.5724 | 535 | 26591232 | 49703.2374 | |
innodb/innodb_temp_file | 105 | 464543640000 | 4424224992 | 30940605168 | 0 | 3641666688 | 460901973312 | 0 | 0 | 0.0000 | 41 | 1589248 | 38762.1463 | |
sql/binlog | 269 | 91265681232 | 339277488 | 18991388064 | 821841504 | 1114593216 | 89329246512 | 62 | 844 | 13.6129 | 7 | 1528 | 218.2857 | |
sql/binlog_index | 38 | 53134159056 | 1398267288 | 30405174096 | 581688624 | 0 | 52552470432 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 55 | 37281379872 | 677843232 | 2740245024 | 20882538864 | 0 | 16398841008 | 33 | 3383272 | 102523.3939 | 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 |
|