SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1604 | 9460885373280 | 5898307536 | 169157118768 | |
wait/io/file/innodb/innodb_data_file | 3889 | 6426176201280 | 1652397912 | 643749785184 | |
wait/io/file/innodb/innodb_temp_file | 275 | 1208500934784 | 4394548752 | 139770565968 | |
wait/io/file/sql/binlog | 775 | 375456617184 | 484460064 | 29778148224 | |
wait/lock/metadata/sql/mdl | 3 | 68328267216 | 22776088896 | 30263647920 | |
wait/io/table/sql/handler | 1594 | 63726096192 | 39978576 | 11132789712 | |
wait/io/file/sql/binlog_index | 38 | 53239004544 | 1401026352 | 27625846512 | |
wait/io/file/sql/ERRMSG | 60 | 41881634784 | 698027088 | 3055911408 | |
wait/io/file/sql/io_cache | 300 | 12393964704 | 41313096 | 2765849328 | |
wait/io/file/csv/metadata | 8 | 5827777296 | 728472096 | 3841314576 | |
wait/io/file/myisam/dfile | 26 | 2153214096 | 82815744 | 1552779360 | |
wait/io/file/myisam/kfile | 12 | 1167469776 | 97289016 | 624771840 | |
wait/lock/table/sql/handler | 754 | 1015225200 | 1346400 | 14333088 | |
wait/io/file/sql/casetest | 15 | 875122512 | 58341360 | 801293856 | |
wait/io/file/csv/data | 9 | 709399152 | 78821952 | 532835952 | |
wait/io/file/sql/misc | 3 | 580445712 | 193481904 | 552951168 | |
wait/io/file/mysys/cnf | 5 | 520020864 | 104004120 | 501498096 | |
wait/io/file/mysys/charset | 3 | 270934224 | 90311232 | 251144256 | |
wait/io/file/sql/pid | 3 | 13564848 | 4521528 | 10959168 |
|