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 | 635 | 3726411984240 | 5868365184 | 117397966224 | 1563639792 | 223286462256 | 3501561882192 | 8 | 70656 | 8832.0000 | 375 | 423424 | 1129.1307 | |
innodb/innodb_data_file | 2416 | 2595936625920 | 1074476832 | 222961337808 | 535153313904 | 39571243536 | 2021212068480 | 1373 | 27607040 | 20107.0940 | 711 | 32686080 | 45971.9831 | |
innodb/innodb_temp_file | 370 | 741461843232 | 2003950872 | 36457674528 | 0 | 31837921632 | 709623921600 | 0 | 0 | 0.0000 | 294 | 6520832 | 22179.7007 | |
sql/binlog | 115 | 161875577952 | 1407613680 | 24927301872 | 3604756320 | 1452507408 | 156818314224 | 21 | 680 | 32.3810 | 12 | 2824 | 235.3333 | |
sql/binlog_index | 38 | 58457567520 | 1538357040 | 41022546576 | 1494270624 | 0 | 56963296896 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 40 | 17150093136 | 428752104 | 1960301904 | 9361254144 | 0 | 7788838992 | 24 | 2443567 | 101815.2917 | 0 | 0 | 0.0000 | |
sql/io_cache | 183 | 13793501568 | 75374112 | 5491645632 | 736841424 | 2688678432 | 10367981712 | 74 | 4631252 | 62584.4865 | 79 | 4631252 | 58623.4430 | |
sql/casetest | 15 | 983535168 | 65568888 | 919182000 | 0 | 0 | 983535168 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 681436272 | 136287096 | 655788144 | 657075408 | 0 | 24360864 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 5 | 317923056 | 63584400 | 267528096 | 0 | 0 | 317923056 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 277080144 | 92359872 | 237049824 | 237049824 | 0 | 40030320 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 14126640 | 4708704 | 9380448 | 0 | 3822192 | 10304448 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|