SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 316 | 1541261044752 | 4877408184 | 56040412560 | |
wait/io/file/innodb/innodb_data_file | 2167 | 1273836474240 | 587834016 | 223637789232 | |
wait/io/file/innodb/innodb_temp_file | 93 | 347230581456 | 3733661976 | 29476837632 | |
wait/io/file/sql/binlog_index | 38 | 44935060896 | 1182501408 | 28975834800 | |
wait/io/file/sql/binlog | 193 | 39622561440 | 205298016 | 19445692992 | |
wait/io/file/sql/ERRMSG | 40 | 28392755424 | 709818648 | 8077798080 | |
wait/io/table/sql/handler | 104 | 3353922528 | 32249184 | 1331571120 | |
wait/io/file/myisam/kfile | 4 | 1518752400 | 379687968 | 1498147200 | |
wait/io/file/sql/casetest | 15 | 807698496 | 53846496 | 724478304 | |
wait/io/file/mysys/cnf | 5 | 503891520 | 100778304 | 485422608 | |
wait/io/file/csv/metadata | 4 | 455496624 | 113874024 | 377682096 | |
wait/io/file/mysys/charset | 3 | 272071008 | 90690336 | 251020176 | |
wait/lock/table/sql/handler | 55 | 66520080 | 1209384 | 3209712 | |
wait/io/file/csv/data | 2 | 20320080 | 10160040 | 13885344 | |
wait/io/file/sql/pid | 3 | 13136640 | 4378704 | 10686720 | |
wait/io/file/myisam/dfile | 2 | 8884128 | 4442064 | 8535120 | |
wait/io/file/sql/misc | 1 | 3913536 | 3913536 | 3913536 |
|