SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_data_file | 1699 | 618255060192 | 363893376 | 175740836304 | |
wait/io/file/innodb/innodb_log_file | 126 | 593203231632 | 4707961896 | 38959229232 | |
wait/io/file/innodb/innodb_temp_file | 180 | 395006355744 | 2194479672 | 30137064672 | |
wait/io/file/sql/binlog | 57 | 48502315488 | 850917672 | 20968599168 | |
wait/io/file/sql/ERRMSG | 35 | 25445874960 | 727024848 | 3963641088 | |
wait/io/table/sql/handler | 109 | 8077435344 | 74104800 | 2679306432 | |
wait/io/file/sql/binlog_index | 23 | 2393642592 | 104071176 | 1695927024 | |
wait/io/file/sql/io_cache | 52 | 1708715712 | 32859816 | 669890496 | |
wait/io/file/sql/casetest | 15 | 766622736 | 51108024 | 696089856 | |
wait/io/file/mysys/cnf | 5 | 251046576 | 50209104 | 232838496 | |
wait/io/file/mysys/charset | 3 | 250019616 | 83339784 | 204451104 | |
wait/lock/table/sql/handler | 46 | 54334368 | 1181136 | 2876016 | |
wait/io/file/sql/misc | 2 | 23291664 | 11645832 | 13735392 | |
wait/io/file/sql/pid | 3 | 17302032 | 5767344 | 14227488 |
|