SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_data_file | 2363 | 3326959396992 | 1407938664 | 790194047280 | |
wait/io/file/innodb/innodb_log_file | 445 | 2529426811296 | 5684105064 | 54661235904 | |
wait/io/file/innodb/innodb_temp_file | 181 | 848752081584 | 4689237960 | 38038033440 | |
wait/io/table/sql/handler | 44405 | 219233526864 | 4937064 | 90089615088 | |
wait/io/file/sql/binlog | 291 | 84544761312 | 290531736 | 35276612448 | |
wait/io/file/sql/binlog_index | 38 | 67107505344 | 1765986816 | 45195054432 | |
wait/io/file/sql/ERRMSG | 60 | 33559257072 | 559320696 | 4711923744 | |
wait/io/file/sql/io_cache | 231 | 10773294048 | 46637448 | 1367745984 | |
wait/io/file/csv/metadata | 8 | 1422855456 | 177856800 | 796118400 | |
wait/io/file/mysys/cnf | 5 | 1119773952 | 223954632 | 1103147760 | |
wait/io/file/sql/casetest | 15 | 896266800 | 59751120 | 823650960 | |
wait/io/file/myisam/kfile | 4 | 754286016 | 188571504 | 737836176 | |
wait/io/file/csv/data | 4 | 681467952 | 170366856 | 634970688 | |
wait/io/file/mysys/charset | 3 | 307035168 | 102344880 | 294577536 | |
wait/lock/table/sql/handler | 116 | 152401920 | 1313664 | 4246704 | |
wait/io/file/sql/pid | 3 | 66067584 | 22022352 | 40676064 | |
wait/io/file/sql/misc | 2 | 30974064 | 15487032 | 17147856 | |
wait/io/file/myisam/dfile | 2 | 6058800 | 3029400 | 5689200 |
|