SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 3591 | 14969863078896 | 4168717080 | 49880452512 | |
wait/io/file/innodb/innodb_data_file | 3813 | 5211310267680 | 1366721664 | 175740836304 | |
wait/io/file/innodb/innodb_temp_file | 786 | 819574134720 | 1042714992 | 30137064672 | |
wait/io/file/sql/binlog | 467 | 704692047840 | 1508976480 | 37110431424 | |
wait/lock/metadata/sql/mdl | 2 | 227664062736 | 113832031368 | 226033181616 | |
wait/io/table/sql/handler | 90744 | 191548209600 | 2110680 | 3438691344 | |
wait/io/file/sql/io_cache | 736 | 105287590320 | 143053680 | 29629451280 | |
wait/io/file/sql/ERRMSG | 70 | 44052488832 | 629321088 | 3963641088 | |
wait/io/file/sql/binlog_index | 23 | 2393642592 | 104071176 | 1695927024 | |
wait/io/file/sql/casetest | 15 | 766622736 | 51108024 | 696089856 | |
wait/lock/table/sql/handler | 566 | 657535824 | 1161600 | 15831024 | |
wait/io/file/mysys/cnf | 5 | 251046576 | 50209104 | 232838496 | |
wait/io/file/mysys/charset | 3 | 250019616 | 83339784 | 204451104 | |
wait/io/file/sql/misc | 4 | 180034272 | 45008568 | 146805120 | |
wait/io/file/sql/pid | 3 | 17302032 | 5767344 | 14227488 |
|