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 | 1899 | 1799186040432 | 0 | 947438448 | 221028791280 | 1241 | 25444352 | 20503.1039 | 368 | 21282816 | 57833.7391 | 46727168 | |
innodb/innodb_temp_file | 113 | 489505909200 | 0 | 4331910528 | 26716167456 | 0 | 0 | 0.0000 | 46 | 1867776 | 40603.8261 | 1867776 | |
sql/ERRMSG | 30 | 18930769440 | 3751440 | 631025472 | 3614289360 | 18 | 1843267 | 102403.7222 | 0 | 0 | 0.0000 | 1843267 | |
innodb/innodb_log_file | 309 | 1755284884320 | 331056 | 5680533408 | 57736431984 | 8 | 70656 | 8832.0000 | 171 | 164864 | 964.1170 | 235520 | |
mysys/charset | 3 | 339086880 | 2524896 | 113028960 | 308294448 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 315 | 96229366464 | 0 | 305489976 | 19907931648 | 73 | 888 | 12.1644 | 8 | 1384 | 173.0000 | 2272 | |
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 | 5 | 68937792 | 0 | 13787400 | 27452832 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|