SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1004 | 5213676828096 | 5192905080 | 39360478608 | |
wait/io/file/innodb/innodb_data_file | 3185 | 2876374840944 | 903100176 | 193056931056 | |
wait/io/file/innodb/innodb_temp_file | 1195 | 1203687348864 | 1007269560 | 63615470688 | |
wait/io/file/sql/binlog | 589 | 209217994656 | 355208568 | 43494271392 | |
wait/io/file/sql/io_cache | 856 | 150035531712 | 175275144 | 87974837280 | |
wait/io/file/sql/ERRMSG | 85 | 49779173136 | 585637272 | 3006702336 | |
wait/io/table/sql/handler | 2434 | 31072133136 | 12765720 | 10816986048 | |
wait/io/file/sql/binlog_index | 23 | 1687327488 | 73361904 | 426533184 | |
wait/lock/table/sql/handler | 556 | 1247667696 | 2244000 | 369060912 | |
wait/io/file/sql/casetest | 15 | 1153361616 | 76890528 | 1088362176 | |
wait/io/file/mysys/charset | 3 | 255759504 | 85252992 | 243990912 | |
wait/io/file/mysys/cnf | 5 | 167694384 | 33538824 | 152746176 | |
wait/io/file/sql/misc | 4 | 68045472 | 17011368 | 30623472 | |
wait/io/file/sql/pid | 3 | 26642880 | 8880960 | 20526000 |
|