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 | 169 | 1695548574192 | 10032831600 | 702658584144 | 1459148592 | 89758408608 | 1604331016992 | 8 | 70656 | 8832.0000 | 90 | 98304 | 1092.2667 | |
innodb/innodb_data_file | 1674 | 1063396381344 | 635242608 | 260410094208 | 213615421536 | 20218073040 | 829562886768 | 1239 | 25411584 | 20509.7530 | 244 | 17678336 | 72452.1967 | |
innodb/innodb_temp_file | 90 | 385286424336 | 4280960112 | 30940605168 | 0 | 3174620064 | 382111804272 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | |
sql/binlog_index | 38 | 53134159056 | 1398267288 | 30405174096 | 581688624 | 0 | 52552470432 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 135 | 51419762064 | 380887056 | 18991388064 | 731703984 | 572251680 | 50115806400 | 30 | 716 | 23.8667 | 4 | 417 | 104.2500 | |
sql/ERRMSG | 30 | 19569017952 | 652300440 | 2740245024 | 10287648624 | 0 | 9281369328 | 18 | 1850070 | 102781.6667 | 0 | 0 | 0.0000 | |
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 | 2 | 187377696 | 93688848 | 174205680 | 0 | 0 | 187377696 | 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 |
|