SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 4004 | 19132698641232 | 4778396040 | 125073982704 | |
wait/io/file/innodb/innodb_data_file | 5060 | 9618391154064 | 1900867584 | 245195382960 | |
wait/io/file/sql/binlog | 725 | 955024419888 | 1317274992 | 24892198320 | |
wait/lock/metadata/sql/mdl | 5 | 868883474976 | 173776694784 | 311754087216 | |
wait/io/file/innodb/innodb_temp_file | 246 | 667570532640 | 2713701144 | 39035314560 | |
wait/io/table/sql/handler | 491790 | 326719380768 | 664224 | 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 | 1052 | 1490503344 | 1416624 | 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 |
|