SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 6245 | 28073698418832 | 4495388040 | 155647343280 | |
wait/io/file/innodb/innodb_data_file | 6476 | 10517451250416 | 1624065960 | 239722177200 | |
wait/io/file/sql/binlog | 982 | 1835552364096 | 1869197880 | 40000099920 | |
wait/lock/metadata/sql/mdl | 5 | 1026627037920 | 205325407584 | 309677198688 | |
wait/io/file/innodb/innodb_temp_file | 189 | 895017386208 | 4735541712 | 31120601952 | |
wait/io/file/sql/binlog_index | 38 | 53601045696 | 1410553584 | 31704022416 | |
wait/io/file/sql/ERRMSG | 60 | 28532245104 | 475537392 | 2282153280 | |
wait/io/file/csv/metadata | 8 | 15293194752 | 1911649344 | 11137947744 | |
wait/io/table/sql/handler | 26 | 2320683024 | 89256816 | 1457329632 | |
wait/io/file/sql/misc | 18 | 1674027696 | 93001392 | 1429414272 | |
wait/io/file/sql/io_cache | 90 | 1505664864 | 16729416 | 52316880 | |
wait/io/file/mysys/cnf | 5 | 1044017568 | 208803408 | 1024878096 | |
wait/io/file/sql/casetest | 15 | 847455312 | 56496792 | 761021184 | |
wait/io/file/myisam/kfile | 4 | 258429600 | 64607400 | 180760272 | |
wait/io/file/mysys/charset | 3 | 256689840 | 85563192 | 238868256 | |
wait/io/file/myisam/dfile | 4 | 158462304 | 39615576 | 134402928 | |
wait/lock/table/sql/handler | 99 | 133207008 | 1345344 | 7423152 | |
wait/io/file/csv/data | 4 | 58489728 | 14622432 | 39568848 | |
wait/io/file/sql/pid | 3 | 13083840 | 4361280 | 10640784 |
|