SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1208 | 6157281149184 | 5097086808 | 37966513200 | |
wait/io/file/innodb/innodb_data_file | 3189 | 3069583303248 | 962553504 | 230358733440 | |
wait/io/file/innodb/innodb_temp_file | 925 | 1176863388096 | 1272284640 | 58998639216 | |
wait/io/file/sql/io_cache | 530 | 149676306912 | 282407928 | 127129271280 | |
wait/io/file/sql/binlog | 153 | 64181877408 | 419489136 | 17455792464 | |
wait/io/file/sql/binlog_index | 38 | 53821200048 | 1416347328 | 35815364640 | |
wait/io/file/sql/ERRMSG | 25 | 17925923664 | 717036936 | 3462545328 | |
wait/io/table/sql/handler | 1091 | 10230359568 | 9377016 | 2877695568 | |
wait/io/file/csv/metadata | 8 | 9413016096 | 1176626880 | 8554132224 | |
wait/io/file/csv/data | 4 | 1582769232 | 395692176 | 847356576 | |
wait/io/file/sql/casetest | 15 | 890187408 | 59345616 | 788670960 | |
wait/io/file/mysys/cnf | 5 | 859982640 | 171996528 | 831023952 | |
wait/io/file/mysys/charset | 3 | 247294080 | 82431360 | 227166192 | |
wait/lock/table/sql/handler | 233 | 243563760 | 1045176 | 3286272 | |
wait/io/file/sql/misc | 3 | 42854592 | 14284776 | 17484192 | |
wait/io/file/sql/pid | 3 | 22796928 | 7598976 | 18620976 |
|