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 | 235 | 1209503268864 | 5146822296 | 87472451088 | 1204353744 | 41256465360 | 1167042449760 | 8 | 70656 | 8832.0000 | 134 | 128512 | 959.0448 | |
innodb/innodb_data_file | 1778 | 940779606624 | 529122264 | 207643000224 | 232731246000 | 10569827664 | 697478532960 | 1287 | 26198016 | 20355.8788 | 295 | 19415040 | 65813.6949 | |
innodb/innodb_temp_file | 110 | 435730473024 | 3961185888 | 27867048528 | 0 | 1171068096 | 434559404928 | 0 | 0 | 0.0000 | 43 | 1818624 | 42293.5814 | |
sql/binlog | 153 | 57673768944 | 376952664 | 21015367824 | 747899328 | 1182711024 | 55743158592 | 36 | 1034 | 28.7222 | 4 | 328 | 82.0000 | |
sql/binlog_index | 38 | 49114161888 | 1292477736 | 33134766192 | 407548944 | 0 | 48706612944 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 40 | 22154142384 | 553853520 | 3217917648 | 12974168064 | 0 | 9179974320 | 24 | 2459577 | 102482.3750 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1665186336 | 333037056 | 1645376304 | 1646557440 | 0 | 18628896 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1194008640 | 79600488 | 1125583008 | 0 | 0 | 1194008640 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 793069200 | 99133584 | 383807424 | 618621168 | 0 | 174448032 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 322158144 | 107385960 | 295564368 | 295564368 | 0 | 26593776 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 38810112 | 9702528 | 14707968 | 0 | 0 | 38810112 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 15001536 | 5000424 | 10210464 | 0 | 4067184 | 10934352 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 3398736 | 3398736 | 3398736 | 0 | 0 | 3398736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|