SELECT * FROM `x$io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_data_file | 1750 | 1307937265008 | 747392712 | 226065427104 | 267057353376 | 23482652688 | 1017397258944 | 1258 | 25722880 | 20447.4404 | 270 | 18399232 | 68145.3037 | |
innodb/innodb_log_file | 206 | 1225613174016 | 5949578448 | 59495663568 | 1574560416 | 24949335312 | 1199089278288 | 8 | 70656 | 8832.0000 | 111 | 109056 | 982.4865 | |
innodb/innodb_temp_file | 121 | 639129912432 | 5282065272 | 63348158016 | 0 | 3407479152 | 635722433280 | 0 | 0 | 0.0000 | 50 | 2195456 | 43909.1200 | |
sql/binlog | 185 | 67631204784 | 365574000 | 20397686496 | 600338640 | 546922992 | 66483943152 | 42 | 764 | 18.1905 | 5 | 641 | 128.2000 | |
sql/binlog_index | 38 | 51742517904 | 1361645208 | 33511287216 | 538724208 | 0 | 51203793696 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 65 | 44647283472 | 686881272 | 6491943744 | 24350126064 | 0 | 20297157408 | 39 | 3991780 | 102353.3333 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1244086800 | 82939032 | 1186486224 | 0 | 0 | 1244086800 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 609487824 | 121897512 | 590212128 | 591517872 | 0 | 17969952 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 286620048 | 95540016 | 271567824 | 271567824 | 0 | 15052224 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 230701152 | 76900296 | 203965872 | 0 | 0 | 230701152 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 118985856 | 39661776 | 80534256 | 0 | 80534256 | 38451600 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|