SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1025 | 5794720456800 | 5653385760 | 136439759808 | |
wait/io/file/innodb/innodb_data_file | 3130 | 4545551247072 | 1452252648 | 217956170256 | |
wait/io/file/innodb/innodb_temp_file | 218 | 1009514111760 | 4630798656 | 36964256736 | |
wait/io/file/sql/binlog | 549 | 430579818240 | 784298328 | 26826885360 | |
wait/io/file/sql/binlog_index | 38 | 67686816384 | 1781231760 | 38375868432 | |
wait/io/table/sql/handler | 1609 | 60037681968 | 37313496 | 27496119552 | |
wait/io/file/sql/ERRMSG | 65 | 32199994464 | 495384384 | 3437607888 | |
wait/io/file/mysys/cnf | 5 | 1832296752 | 366459192 | 1804780032 | |
wait/io/file/sql/SDI | 12 | 1232249568 | 102687288 | 1034921184 | |
wait/io/file/sql/casetest | 15 | 948929520 | 63261792 | 881293776 | |
wait/io/file/csv/metadata | 8 | 945287376 | 118160856 | 456174576 | |
wait/io/file/myisam/kfile | 84 | 745011696 | 8869080 | 347071296 | |
wait/lock/table/sql/handler | 618 | 709227024 | 1147608 | 3570336 | |
wait/io/file/myisam/dfile | 140 | 684407328 | 4888488 | 343854720 | |
wait/io/file/sql/misc | 6 | 281245008 | 46873992 | 214444560 | |
wait/io/file/mysys/charset | 3 | 251701296 | 83900256 | 232741872 | |
wait/io/file/csv/data | 9 | 94456560 | 10495056 | 25722048 | |
wait/io/file/sql/pid | 3 | 16624080 | 5541360 | 11281248 |
|