SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 10914 | 48805852870896 | 4471857456 | 229806344064 | |
wait/io/file/innodb/innodb_data_file | 9742 | 18117689537904 | 1859750376 | 239722177200 | |
wait/lock/metadata/sql/mdl | 22 | 3736950112368 | 169861368600 | 309677198688 | |
wait/io/file/sql/binlog | 1639 | 2630284634736 | 1604810592 | 40000099920 | |
wait/io/file/innodb/innodb_temp_file | 683 | 1326860138208 | 1942694160 | 35047542288 | |
wait/io/file/sql/io_cache | 480 | 105122204352 | 219004368 | 94166709648 | |
wait/io/file/sql/binlog_index | 38 | 53601045696 | 1410553584 | 31704022416 | |
wait/io/file/sql/ERRMSG | 70 | 35022898416 | 500326992 | 2282153280 | |
wait/io/file/csv/metadata | 8 | 15293194752 | 1911649344 | 11137947744 | |
wait/io/table/sql/handler | 40 | 3222577776 | 80564352 | 1457329632 | |
wait/io/file/sql/misc | 24 | 1720862880 | 71702400 | 1429414272 | |
wait/io/file/mysys/cnf | 5 | 1044017568 | 208803408 | 1024878096 | |
wait/io/file/sql/casetest | 15 | 847455312 | 56496792 | 761021184 | |
wait/lock/table/sql/handler | 246 | 359316144 | 1460448 | 7423152 | |
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/io/file/csv/data | 4 | 58489728 | 14622432 | 39568848 | |
wait/io/file/sql/pid | 3 | 13083840 | 4361280 | 10640784 |
|