SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 749 | 4219644198000 | 5633703768 | 168557720496 | |
wait/io/file/innodb/innodb_data_file | 2763 | 1775562773424 | 642621144 | 221510328336 | |
wait/io/file/innodb/innodb_temp_file | 109 | 589774268688 | 5410772928 | 58250533440 | |
wait/io/file/sql/binlog | 123 | 65108728608 | 529339008 | 21021120384 | |
wait/io/file/sql/binlog_index | 38 | 49136614032 | 1293068568 | 26204664816 | |
wait/io/file/myisam/kfile | 16 | 23917755312 | 1494859608 | 20319073632 | |
wait/io/file/sql/ERRMSG | 30 | 11622879312 | 387429240 | 2271437520 | |
wait/io/table/sql/handler | 1484 | 7505910720 | 5057712 | 1269722256 | |
wait/io/file/csv/metadata | 8 | 1268652528 | 158581368 | 556447584 | |
wait/io/file/sql/casetest | 15 | 779176464 | 51944904 | 708505776 | |
wait/io/file/mysys/cnf | 5 | 680415120 | 136083024 | 664385040 | |
wait/io/file/csv/data | 4 | 596576640 | 149144160 | 494795136 | |
wait/lock/table/sql/handler | 371 | 374314512 | 1008744 | 4757280 | |
wait/io/file/mysys/charset | 3 | 237257856 | 79085952 | 223522992 | |
wait/io/file/myisam/dfile | 8 | 39696624 | 4961880 | 15249696 | |
wait/io/file/sql/pid | 3 | 36875520 | 12291840 | 29035776 | |
wait/io/file/sql/misc | 1 | 13166208 | 13166208 | 13166208 |
|