SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 483 | 2772215311008 | 5739575952 | 115820214576 | |
wait/io/file/innodb/innodb_data_file | 2343 | 2303163507216 | 982997400 | 207032278992 | |
wait/io/file/innodb/innodb_temp_file | 221 | 568066389792 | 2570436000 | 30101811168 | |
wait/io/table/sql/handler | 5650 | 87189027024 | 15431592 | 55892683968 | |
wait/io/file/sql/binlog_index | 38 | 58323102816 | 1534818384 | 39997884432 | |
wait/io/file/sql/binlog | 127 | 46625012544 | 367126056 | 15104590512 | |
wait/io/file/sql/ERRMSG | 65 | 28457226864 | 437803344 | 3282888048 | |
wait/io/file/sql/io_cache | 80 | 2545545024 | 31819128 | 1198141824 | |
wait/lock/table/sql/handler | 1107 | 1224628944 | 1106160 | 25508736 | |
wait/io/file/sql/casetest | 15 | 893491104 | 59566056 | 831215616 | |
wait/io/file/myisam/dfile | 29 | 745210752 | 25696704 | 717407856 | |
wait/io/file/mysys/cnf | 5 | 614475312 | 122894904 | 590587008 | |
wait/io/file/mysys/charset | 3 | 242493504 | 80830992 | 223660272 | |
wait/io/file/myisam/kfile | 4 | 203247792 | 50811816 | 181513728 | |
wait/lock/metadata/sql/mdl | 2 | 59058384 | 29529192 | 29832528 | |
wait/io/file/sql/misc | 2 | 16741296 | 8370648 | 14024736 | |
wait/io/file/sql/pid | 3 | 13651440 | 4550304 | 11177760 |
|