SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 3245 | 17574972606048 | 5416015968 | 158342062560 | |
wait/io/file/innodb/innodb_data_file | 4555 | 9080718953328 | 1993571448 | 240921342288 | |
wait/io/file/sql/binlog | 542 | 824020564752 | 1520332968 | 33133161600 | |
wait/io/file/innodb/innodb_temp_file | 93 | 343737067344 | 3696097416 | 24018608064 | |
wait/lock/metadata/sql/mdl | 1 | 258279353904 | 258279353904 | 258279353904 | |
wait/io/file/sql/io_cache | 100 | 89291171904 | 892911624 | 85760888400 | |
wait/io/file/sql/binlog_index | 38 | 53865346128 | 1417508928 | 29695612848 | |
wait/io/file/sql/ERRMSG | 75 | 42858538272 | 571447008 | 3649562400 | |
wait/io/table/sql/handler | 1256 | 17458335840 | 13899864 | 4081908336 | |
wait/io/file/csv/metadata | 8 | 4291449360 | 536431104 | 2145597696 | |
wait/io/file/myisam/kfile | 16 | 4182700368 | 261418608 | 1705343376 | |
wait/io/file/mysys/cnf | 5 | 1414599120 | 282919824 | 1394431632 | |
wait/io/file/sql/misc | 12 | 917110128 | 76425624 | 664013328 | |
wait/io/file/sql/casetest | 15 | 825783024 | 55052184 | 753272784 | |
wait/lock/table/sql/handler | 441 | 521398416 | 1182192 | 15548016 | |
wait/io/file/csv/data | 15 | 336576240 | 22438416 | 73673424 | |
wait/io/file/myisam/dfile | 87 | 333091440 | 3828528 | 251670672 | |
wait/io/file/mysys/charset | 3 | 243230592 | 81076776 | 228088080 | |
wait/io/file/sql/pid | 3 | 13728528 | 4576176 | 11288640 |
|