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 | 2645 | 3365506716000 | 0 | 1272403176 | 221028791280 | 1433 | 28590080 | 19951.2073 | 751 | 32882688 | 43785.2037 | 61472768 | |
innodb/innodb_temp_file | 134 | 618169312464 | 0 | 4613203584 | 26716167456 | 0 | 0 | 0.0000 | 60 | 2555904 | 42598.4000 | 2555904 | |
sql/ERRMSG | 40 | 26938859904 | 3751440 | 673471392 | 3614289360 | 24 | 2465379 | 102724.1250 | 0 | 0 | 0.0000 | 2465379 | |
innodb/innodb_log_file | 606 | 3862935733536 | 331056 | 6374481168 | 120288658512 | 8 | 70656 | 8832.0000 | 342 | 315904 | 923.6959 | 386560 | |
mysys/charset | 3 | 339086880 | 2524896 | 113028960 | 308294448 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 571 | 217397757984 | 0 | 380731560 | 22442431968 | 133 | 1128 | 8.4812 | 16 | 3567 | 222.9375 | 4695 | |
myisam/kfile | 4 | 1387549680 | 2365968 | 346887288 | 1308118416 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 49556581008 | 0 | 1304120400 | 31372146960 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1890121728 | 157872 | 378024240 | 1870909392 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 12418560 | 567072 | 4139520 | 9793872 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 735476544 | 0 | 49031664 | 658995216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 9 | 250763040 | 0 | 27862560 | 142269072 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 29317200 | 1735536 | 14658600 | 27581664 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|