SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 9239 | 46346008751328 | 5016344520 | 919435474320 | |
wait/io/file/innodb/innodb_data_file | 13197 | 16185212611392 | 1226431008 | 232021741776 | |
wait/io/file/innodb/innodb_temp_file | 463 | 1039698227568 | 2245568424 | 35850292368 | |
wait/io/file/sql/binlog | 705 | 927911323680 | 1316186256 | 35429138448 | |
wait/lock/metadata/sql/mdl | 3 | 292396086048 | 97465361928 | 204532791936 | |
wait/io/table/sql/handler | 35356 | 89007922608 | 2517240 | 4318423296 | |
wait/io/file/sql/binlog_index | 38 | 47470518480 | 1249223976 | 29062866096 | |
wait/io/file/sql/ERRMSG | 80 | 44672602656 | 558407520 | 4029245088 | |
wait/io/file/sql/io_cache | 496 | 10307598576 | 20781288 | 693027984 | |
wait/lock/table/sql/handler | 5068 | 5488387344 | 1082928 | 416643744 | |
wait/io/file/csv/metadata | 8 | 3181118160 | 397639704 | 1977272880 | |
wait/io/file/mysys/cnf | 5 | 1649662080 | 329932416 | 1621887168 | |
wait/io/file/myisam/kfile | 12 | 1523096256 | 126924600 | 975839040 | |
wait/io/file/sql/casetest | 15 | 738594912 | 49239432 | 669116976 | |
wait/io/file/myisam/dfile | 7 | 608705328 | 86957904 | 564436224 | |
wait/io/file/csv/data | 17 | 401985408 | 23645952 | 263191632 | |
wait/io/file/mysys/charset | 3 | 246056448 | 82018728 | 234769920 | |
wait/io/file/sql/misc | 6 | 104542944 | 17423736 | 37932576 | |
wait/io/file/sql/pid | 3 | 49460400 | 16486800 | 38805360 |
|