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_data_file | 2424 | 3513655348896 | 1449527640 | 996788410464 | 327678040800 | 48202630608 | 3137774677488 | 1456 | 28966912 | 19894.8571 | 625 | 29474816 | 47159.7056 | |
innodb/innodb_log_file | 475 | 2960134924032 | 6231862824 | 179715614496 | 1821177600 | 189723166512 | 2768590579920 | 8 | 70656 | 8832.0000 | 275 | 244736 | 889.9491 | |
innodb/innodb_temp_file | 211 | 1224134004192 | 5801582952 | 41046188832 | 0 | 7112292528 | 1217021711664 | 0 | 0 | 0.0000 | 111 | 5095424 | 45904.7207 | |
sql/binlog | 675 | 109418520288 | 162101280 | 21343845600 | 1457264160 | 1052278128 | 106908978000 | 165 | 1550 | 9.3939 | 7 | 1078 | 154.0000 | |
sql/binlog_index | 38 | 56128760688 | 1477072608 | 34500855312 | 2403143952 | 0 | 53725616736 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 40 | 37349882064 | 933746880 | 12895036704 | 13493354160 | 0 | 23856527904 | 24 | 2451954 | 102164.7500 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 2355426480 | 294428112 | 1059133152 | 1693733184 | 0 | 661693296 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 1517761872 | 379440336 | 1466863728 | 1475812800 | 0 | 41949072 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1179660240 | 78644016 | 1115802864 | 0 | 0 | 1179660240 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 712654800 | 178163568 | 492814080 | 0 | 0 | 712654800 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 519524016 | 103904592 | 489543120 | 491060064 | 0 | 28463952 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 306014544 | 102004848 | 294038976 | 294038976 | 0 | 11975568 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 43793904 | 10948344 | 16153632 | 0 | 0 | 43793904 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 2 | 33545952 | 16772976 | 32081808 | 0 | 0 | 33545952 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 30386928 | 10128888 | 18897648 | 0 | 10118064 | 20268864 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|