SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 311 | 1500764632224 | 4825609536 | 31100957712 | |
wait/io/file/innodb/innodb_data_file | 2121 | 1313301456720 | 619189560 | 59703357120 | |
wait/io/file/innodb/innodb_temp_file | 727 | 844703063952 | 1161902280 | 129964785984 | |
wait/io/table/sql/handler | 980287 | 618919243536 | 631224 | 4403478816 | |
wait/io/file/sql/binlog | 295 | 95364820848 | 323270376 | 22179567696 | |
wait/io/file/sql/ERRMSG | 65 | 39909159312 | 613986912 | 3442136016 | |
wait/io/file/sql/io_cache | 104 | 18862065552 | 181365888 | 10950693600 | |
wait/io/file/myisam/kfile | 12 | 2475383856 | 206281944 | 1131125424 | |
wait/io/file/sql/casetest | 15 | 844752480 | 56316744 | 746966880 | |
wait/io/file/sql/binlog_index | 23 | 784074192 | 34090056 | 260070096 | |
wait/io/file/mysys/charset | 3 | 443030016 | 147676584 | 401792688 | |
wait/lock/table/sql/handler | 208 | 227590176 | 1094016 | 7295376 | |
wait/io/file/mysys/cnf | 5 | 214828416 | 42965472 | 194608656 | |
wait/io/file/csv/metadata | 4 | 204852912 | 51213096 | 141318672 | |
wait/io/file/sql/misc | 3 | 197919216 | 65973072 | 179606064 | |
wait/lock/metadata/sql/mdl | 1 | 58646016 | 58646016 | 58646016 | |
wait/io/file/myisam/dfile | 7 | 32897040 | 4699464 | 10560528 | |
wait/io/file/csv/data | 6 | 24096336 | 4015968 | 9553632 | |
wait/io/file/sql/pid | 3 | 13544256 | 4514664 | 11204160 |
|