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 | 2135 | 1833062991408 | 0 | 858577368 | 210274326240 | 1367 | 27508736 | 20123.4353 | 472 | 24625152 | 52171.9322 | 52133888 | |
sql/ERRMSG | 90 | 55682522544 | 2783616 | 618694560 | 6022850064 | 54 | 5522137 | 102261.7963 | 0 | 0 | 0.0000 | 5522137 | |
innodb/innodb_temp_file | 179 | 882082730496 | 0 | 4927836408 | 34915695408 | 0 | 0 | 0.0000 | 90 | 4030464 | 44782.9333 | 4030464 | |
sql/io_cache | 50 | 1823999760 | 0 | 36479784 | 440371536 | 18 | 1245448 | 69191.5556 | 22 | 1245448 | 56611.2727 | 2490896 | |
innodb/innodb_log_file | 307 | 1972067638992 | 231264 | 6423673080 | 66550636416 | 8 | 70656 | 8832.0000 | 171 | 159232 | 931.1813 | 229888 | |
mysys/charset | 3 | 289142304 | 3454704 | 96380592 | 267292608 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 1375 | 114313870176 | 0 | 83137296 | 27366650784 | 339 | 1952 | 5.7581 | 6 | 890 | 148.3333 | 2842 | |
sql/binlog_index | 38 | 57742893648 | 0 | 1519549680 | 35666929056 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 582349680 | 166320 | 116469936 | 562906608 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13264416 | 691680 | 4421472 | 10730544 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 854542128 | 0 | 56969352 | 758005248 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 57574704 | 0 | 14393544 | 32636736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|