SELECT * FROM `x$io_global_by_wait_by_bytes`
|
event_name | total | total_latency | min_latency | avg_latency | max_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | total_requested | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_data_file | 2360 | 2509818431472 | 0 | 1063482288 | 208083682752 | 1338 | 27033600 | 20204.4843 | 629 | 29409280 | 46755.6121 | 56442880 | |
sql/io_cache | 752 | 206985863040 | 0 | 275246928 | 174451320384 | 286 | 17950696 | 62764.6713 | 316 | 17950696 | 56806.0000 | 35901392 | |
innodb/innodb_temp_file | 236 | 865684167216 | 0 | 3668153016 | 60772853328 | 0 | 0 | 0.0000 | 155 | 4571136 | 29491.2000 | 4571136 | |
sql/ERRMSG | 45 | 34148213616 | 2836944 | 758848992 | 4111931472 | 27 | 2779576 | 102947.2593 | 0 | 0 | 0.0000 | 2779576 | |
innodb/innodb_log_file | 494 | 2939730843456 | 229152 | 5950872048 | 35660866032 | 8 | 70656 | 8832.0000 | 281 | 232960 | 829.0391 | 303616 | |
mysys/charset | 3 | 238380912 | 2110944 | 79460304 | 226367856 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 149 | 35730222528 | 0 | 239799912 | 15695089872 | 34 | 732 | 21.5294 | 3 | 156 | 52.0000 | 888 | |
myisam/kfile | 4 | 326160384 | 5896176 | 81540096 | 271920528 | 2 | 392 | 196.0000 | 0 | 0 | 0.0000 | 392 | |
sql/binlog_index | 38 | 63370101168 | 0 | 1667634144 | 44962586592 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 2351976528 | 182688 | 470395200 | 2335804944 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 69067680 | 4638480 | 23022384 | 53658000 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 835143936 | 0 | 55676016 | 758282448 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 5315376 | 0 | 5315376 | 5315376 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 25044096 | 2439360 | 12522048 | 22604736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|