SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 716 | 3760228279104 | 5251715304 | 88616485584 | |
wait/io/file/innodb/innodb_data_file | 2757 | 2419262266080 | 877497984 | 216016924992 | |
wait/io/file/innodb/innodb_temp_file | 281 | 1130139344400 | 4021848072 | 506314111776 | |
wait/io/file/sql/binlog_index | 38 | 52280884128 | 1375812504 | 31810602912 | |
wait/io/file/sql/binlog | 193 | 39564091248 | 204995208 | 16373781600 | |
wait/io/file/sql/ERRMSG | 55 | 34912686864 | 634776120 | 3720434784 | |
wait/io/table/sql/handler | 721 | 15133389744 | 20989320 | 3088779936 | |
wait/io/file/sql/casetest | 15 | 782074656 | 52138152 | 714263088 | |
wait/io/file/mysys/cnf | 5 | 707314080 | 141462816 | 682972224 | |
wait/io/file/csv/metadata | 4 | 490237440 | 122559360 | 423382608 | |
wait/io/file/myisam/kfile | 4 | 315853296 | 78963192 | 298757712 | |
wait/io/file/mysys/charset | 3 | 258325584 | 86108352 | 231950400 | |
wait/lock/table/sql/handler | 233 | 214893888 | 922152 | 5025504 | |
wait/io/file/sql/pid | 3 | 48771360 | 16257120 | 37691808 | |
wait/io/file/csv/data | 2 | 25324464 | 12662232 | 19603584 | |
wait/io/file/sql/misc | 1 | 15009984 | 15009984 | 15009984 | |
wait/io/file/myisam/dfile | 2 | 7321248 | 3660624 | 6920496 |
|