SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 3993 | 19060618527984 | 4773508080 | 125073982704 | |
wait/io/file/innodb/innodb_data_file | 5047 | 9561683288784 | 1894527888 | 245195382960 | |
wait/io/file/sql/binlog | 721 | 955004403408 | 1324555320 | 24892198320 | |
wait/lock/metadata/sql/mdl | 5 | 868883474976 | 173776694784 | 311754087216 | |
wait/io/file/innodb/innodb_temp_file | 243 | 650194987200 | 2675699400 | 39035314560 | |
wait/io/table/sql/handler | 491592 | 325561361664 | 662112 | 4135042560 | |
wait/io/file/sql/binlog_index | 38 | 43323090096 | 1140081096 | 26377545216 | |
wait/io/file/sql/ERRMSG | 70 | 32140684752 | 459152496 | 5403006048 | |
wait/lock/table/sql/handler | 899 | 1347395808 | 1498728 | 440720544 | |
wait/io/file/sql/io_cache | 38 | 1209237744 | 31822032 | 505066848 | |
wait/io/file/sql/casetest | 15 | 929067744 | 61937832 | 804072192 | |
wait/io/file/mysys/cnf | 5 | 704283888 | 140856672 | 685674000 | |
wait/io/file/csv/metadata | 8 | 511410768 | 63926280 | 213491520 | |
wait/io/file/sql/misc | 8 | 244046880 | 30505728 | 158440656 | |
wait/io/file/mysys/charset | 3 | 225954432 | 75318144 | 210361536 | |
wait/io/file/csv/data | 4 | 177989856 | 44497464 | 143681472 | |
wait/io/file/sql/pid | 3 | 13593888 | 4531296 | 11100144 |
|