SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 510 | 3203612619504 | 6281593296 | 137615227200 | |
wait/io/file/innodb/innodb_data_file | 2222 | 2315071829136 | 1041886296 | 257343495024 | |
wait/io/file/innodb/innodb_temp_file | 246 | 2033156131776 | 8264862144 | 608638992192 | |
wait/io/table/sql/handler | 220 | 269764871904 | 1226203704 | 258356147808 | |
wait/io/file/sql/binlog | 221 | 57190598256 | 258780984 | 24559649664 | |
wait/io/file/sql/binlog_index | 38 | 51224369856 | 1348009608 | 25411254528 | |
wait/io/file/sql/ERRMSG | 50 | 37066342896 | 741326784 | 3395446560 | |
wait/io/file/sql/io_cache | 77 | 2596620576 | 33722304 | 405443808 | |
wait/io/file/myisam/kfile | 4 | 1306944672 | 326736168 | 1252646736 | |
wait/io/file/sql/casetest | 15 | 937547424 | 62503056 | 863439984 | |
wait/io/file/mysys/cnf | 5 | 797037648 | 159407424 | 780801120 | |
wait/io/file/mysys/charset | 3 | 293856816 | 97952184 | 280338960 | |
wait/io/file/csv/metadata | 4 | 255949056 | 63987264 | 162553776 | |
wait/io/file/csv/data | 2 | 214508976 | 107254488 | 203436816 | |
wait/lock/table/sql/handler | 156 | 192261696 | 1232352 | 14457168 | |
wait/io/file/sql/pid | 3 | 45367872 | 15122448 | 35089824 | |
wait/io/file/myisam/dfile | 2 | 30249648 | 15124824 | 28919088 | |
wait/io/file/sql/misc | 1 | 11758560 | 11758560 | 11758560 |
|