SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 2984 | 15306709234608 | 5129594184 | 232667263488 | |
wait/io/file/innodb/innodb_data_file | 5399 | 9280899616560 | 1719003264 | 198498515952 | |
wait/io/file/innodb/innodb_temp_file | 415 | 2012127143136 | 4848499128 | 430788258912 | |
wait/io/file/sql/binlog | 865 | 1618203922896 | 1870755744 | 33625497312 | |
wait/io/table/sql/handler | 1962786 | 1091542969968 | 555984 | 20366617920 | |
wait/lock/metadata/sql/mdl | 4 | 314565546768 | 78641386560 | 224410622304 | |
wait/io/file/sql/binlog_index | 38 | 51565640016 | 1356990360 | 34978297728 | |
wait/io/file/sql/ERRMSG | 45 | 34133476608 | 758521632 | 9018566832 | |
wait/io/file/csv/metadata | 8 | 4179483264 | 522435408 | 1603221312 | |
wait/lock/table/sql/handler | 1084 | 1650682704 | 1522752 | 100437744 | |
wait/io/file/mysys/cnf | 5 | 1336449312 | 267289704 | 1318897536 | |
wait/io/file/sql/casetest | 15 | 910048128 | 60669840 | 839172576 | |
wait/io/file/csv/data | 4 | 864723024 | 216180624 | 805551648 | |
wait/io/file/myisam/kfile | 4 | 618404160 | 154601040 | 594906048 | |
wait/io/file/sql/misc | 3 | 311083872 | 103694448 | 293603904 | |
wait/io/file/mysys/charset | 3 | 304270560 | 101423520 | 262034784 | |
wait/io/file/sql/pid | 3 | 12713712 | 4237728 | 10369392 | |
wait/io/file/myisam/dfile | 2 | 9832944 | 4916472 | 9354576 |
|