SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 10386 | 46232565806592 | 4451431248 | 229806344064 | |
wait/io/file/innodb/innodb_data_file | 9003 | 16496624827584 | 1832347440 | 239722177200 | |
wait/lock/metadata/sql/mdl | 22 | 3736950112368 | 169861368600 | 309677198688 | |
wait/io/file/sql/binlog | 1216 | 2473759667808 | 2034341760 | 40000099920 | |
wait/io/file/innodb/innodb_temp_file | 384 | 1014158335344 | 2641037256 | 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/file/sql/io_cache | 210 | 4613179824 | 21967440 | 433670688 | |
wait/io/table/sql/handler | 17 | 2180575584 | 128269152 | 1457329632 | |
wait/io/file/sql/misc | 20 | 1688899872 | 84444888 | 1429414272 | |
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/lock/table/sql/handler | 115 | 168453648 | 1464672 | 7423152 | |
wait/io/file/myisam/dfile | 4 | 158462304 | 39615576 | 134402928 | |
wait/io/file/csv/data | 4 | 58489728 | 14622432 | 39568848 | |
wait/io/file/sql/pid | 3 | 13083840 | 4361280 | 10640784 |
|