SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 520 | 2641173058128 | 5079178896 | 76102733520 | |
wait/io/file/innodb/innodb_data_file | 2042 | 1156145537184 | 566182848 | 222708028752 | |
wait/io/file/innodb/innodb_temp_file | 99 | 347376100368 | 3508849344 | 29779137168 | |
wait/io/file/sql/binlog | 145 | 70037053152 | 483014136 | 26497828896 | |
wait/io/file/sql/binlog_index | 38 | 53601045696 | 1410553584 | 31704022416 | |
wait/io/file/sql/ERRMSG | 35 | 18521888880 | 529196712 | 2282153280 | |
wait/io/table/sql/handler | 61 | 5095840464 | 83538312 | 1457329632 | |
wait/io/file/mysys/cnf | 5 | 1044017568 | 208803408 | 1024878096 | |
wait/io/file/sql/casetest | 15 | 847455312 | 56496792 | 761021184 | |
wait/io/file/sql/io_cache | 30 | 540561120 | 18018528 | 52316880 | |
wait/io/file/mysys/charset | 3 | 256689840 | 85563192 | 238868256 | |
wait/lock/table/sql/handler | 23 | 31285056 | 1360128 | 7423152 | |
wait/io/file/sql/misc | 3 | 29123424 | 9707808 | 14323584 | |
wait/io/file/sql/pid | 3 | 13083840 | 4361280 | 10640784 |
|