SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_data_file | 2002 | 2022962977728 | 1010470824 | 261071745792 | |
wait/io/file/innodb/innodb_log_file | 336 | 2022638810544 | 6019758360 | 92903915808 | |
wait/io/file/innodb/innodb_temp_file | 99 | 436189536288 | 4405954872 | 31783754112 | |
wait/io/file/sql/binlog | 307 | 65081187600 | 211990680 | 19954627968 | |
wait/io/file/sql/binlog_index | 38 | 64774600176 | 1704594672 | 39646162512 | |
wait/io/file/sql/ERRMSG | 60 | 49472559840 | 824542488 | 5604414816 | |
wait/io/table/sql/handler | 476 | 20040691968 | 42102192 | 3974872176 | |
wait/io/file/csv/metadata | 4 | 2095711200 | 523927800 | 1437968400 | |
wait/io/file/sql/io_cache | 54 | 1654784736 | 30644064 | 730584096 | |
wait/io/file/mysys/cnf | 5 | 1645186224 | 329037192 | 1629269136 | |
wait/io/file/sql/casetest | 15 | 1203891216 | 80259168 | 1136176800 | |
wait/io/file/sql/misc | 2 | 422218896 | 211109448 | 410702688 | |
wait/io/file/mysys/charset | 3 | 279370608 | 93123360 | 261430752 | |
wait/lock/table/sql/handler | 180 | 173204592 | 962016 | 4471632 | |
wait/io/file/sql/pid | 3 | 50090832 | 16696944 | 38905680 | |
wait/io/file/csv/data | 8 | 33531696 | 4191264 | 11687280 |
|