SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1046 | 5581367506704 | 5335915200 | 105473561424 | |
wait/io/file/innodb/innodb_data_file | 3362 | 4282548749424 | 1273809768 | 706264669440 | |
wait/io/file/innodb/innodb_temp_file | 230 | 1051465725552 | 4571590056 | 32905463184 | |
wait/io/file/sql/binlog | 1864 | 200130216000 | 107365896 | 21567158448 | |
wait/io/table/sql/handler | 133386 | 155301709200 | 1164240 | 3804024048 | |
wait/io/file/sql/binlog_index | 38 | 62485614048 | 1644358056 | 41415482064 | |
wait/io/file/sql/ERRMSG | 75 | 42256839504 | 563424312 | 4292584560 | |
wait/io/file/sql/io_cache | 310 | 8737970736 | 28186752 | 806105520 | |
wait/io/file/myisam/kfile | 16 | 5989111920 | 374319264 | 4419574896 | |
wait/io/file/csv/metadata | 8 | 3864203904 | 483025488 | 2189649792 | |
wait/io/file/sql/misc | 7 | 1077328032 | 153903816 | 853991952 | |
wait/io/file/sql/casetest | 15 | 684531408 | 45635304 | 625672080 | |
wait/lock/table/sql/handler | 545 | 571670352 | 1048872 | 3036528 | |
wait/io/file/mysys/cnf | 5 | 503935872 | 100787016 | 485975424 | |
wait/io/file/mysys/charset | 3 | 311504688 | 103834896 | 297673728 | |
wait/io/file/sql/pid | 3 | 54096768 | 18032256 | 39228816 | |
wait/io/file/myisam/dfile | 8 | 48280848 | 6035040 | 15809376 | |
wait/io/file/csv/data | 4 | 44451264 | 11112816 | 20286288 |
|