SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 2052 | 9171503147664 | 4469543232 | 114949024608 | |
wait/io/file/innodb/innodb_data_file | 4053 | 4721760745680 | 1165003752 | 679879651968 | |
wait/io/file/innodb/innodb_temp_file | 276 | 812186840784 | 2942705832 | 37375926720 | |
wait/io/file/sql/io_cache | 170 | 664759027152 | 3910347144 | 464072007168 | |
wait/io/file/sql/binlog | 231 | 504939258912 | 2185884096 | 27204531552 | |
wait/lock/metadata/sql/mdl | 1 | 280454347008 | 280454347008 | 280454347008 | |
wait/io/file/sql/binlog_index | 38 | 45986038560 | 1210158840 | 29645548944 | |
wait/io/file/sql/ERRMSG | 50 | 44130455952 | 882609024 | 7904142576 | |
wait/io/file/csv/metadata | 8 | 8303239824 | 1037904912 | 7048165344 | |
wait/io/table/sql/handler | 3 | 2243717520 | 747905664 | 2179336368 | |
wait/io/file/mysys/cnf | 5 | 1803762048 | 360752304 | 1767272496 | |
wait/io/file/sql/casetest | 15 | 857192688 | 57145968 | 777431424 | |
wait/io/file/myisam/kfile | 9 | 832103712 | 92455968 | 555111216 | |
wait/io/file/mysys/charset | 3 | 311792448 | 103930728 | 279432912 | |
wait/io/file/sql/misc | 4 | 183949920 | 45987480 | 152258304 | |
wait/lock/table/sql/handler | 42 | 66459888 | 1582152 | 4445232 | |
wait/io/file/myisam/dfile | 7 | 44035200 | 6290592 | 10045728 | |
wait/io/file/csv/data | 4 | 40286928 | 10071600 | 16657872 | |
wait/io/file/sql/pid | 3 | 17499504 | 5833080 | 13821456 |
|