SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1221 | 7200054510528 | 5896850520 | 66504710976 | |
wait/io/file/innodb/innodb_data_file | 3442 | 5134605102000 | 1491750216 | 217769768832 | |
wait/io/table/sql/handler | 2363120 | 2215829647680 | 937464 | 12982064832 | |
wait/io/file/innodb/innodb_temp_file | 148 | 750876266976 | 5073488112 | 45681657120 | |
wait/io/file/sql/binlog | 295 | 124940810544 | 423528072 | 21872938560 | |
wait/io/file/sql/binlog_index | 38 | 46624287072 | 1226954784 | 29608567296 | |
wait/io/file/sql/ERRMSG | 60 | 41299455648 | 688324032 | 2335312320 | |
wait/io/file/myisam/kfile | 12 | 4031245680 | 335937096 | 3093195600 | |
wait/io/file/csv/metadata | 8 | 2092014144 | 261501768 | 1143780528 | |
wait/io/file/mysys/cnf | 5 | 1613411712 | 322682184 | 1595294448 | |
wait/lock/table/sql/handler | 1197 | 1236796176 | 1033032 | 4984320 | |
wait/io/file/sql/casetest | 15 | 794786784 | 52985592 | 729273600 | |
wait/io/file/sql/misc | 4 | 783598464 | 195899616 | 680217120 | |
wait/io/file/sql/io_cache | 15 | 463298352 | 30886416 | 219344400 | |
wait/io/file/myisam/dfile | 17 | 443628768 | 26095608 | 299586672 | |
wait/io/file/mysys/charset | 3 | 279845808 | 93281760 | 264750816 | |
wait/io/file/csv/data | 20 | 148011600 | 7400448 | 38676000 | |
wait/io/file/sql/pid | 3 | 12715296 | 4238256 | 10026720 |
|