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 | 2086 | 1494717914976 | 0 | 716547216 | 254433478992 | 1400 | 28049408 | 20035.2914 | 433 | 23773184 | 54903.4273 | 51822592 | |
sql/io_cache | 182 | 12326298864 | 0 | 67726824 | 4247390928 | 79 | 4203440 | 53208.1013 | 73 | 4194692 | 57461.5342 | 8398132 | |
innodb/innodb_temp_file | 213 | 1007369297616 | 0 | 4729433280 | 40008205248 | 0 | 0 | 0.0000 | 114 | 5079040 | 44552.9825 | 5079040 | |
sql/ERRMSG | 60 | 43668551520 | 3016992 | 727809192 | 3760052736 | 36 | 3681181 | 102255.0278 | 0 | 0 | 0.0000 | 3681181 | |
innodb/innodb_log_file | 417 | 2296802606208 | 230736 | 5507919912 | 79935907392 | 8 | 70656 | 8832.0000 | 243 | 212992 | 876.5103 | 283648 | |
mysys/charset | 3 | 250122576 | 2075040 | 83374104 | 234278352 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 265 | 36159136992 | 0 | 136449456 | 16810064832 | 63 | 848 | 13.4603 | 3 | 156 | 52.0000 | 1004 | |
sql/binlog_index | 38 | 50050963776 | 0 | 1317130584 | 32078148960 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 789756000 | 616176 | 98719368 | 404559936 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 556289712 | 151008 | 111257784 | 537826608 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13883760 | 574992 | 4627920 | 10577424 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 905420208 | 0 | 60361224 | 839598672 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 3815856 | 0 | 3815856 | 3815856 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 19 | 150797328 | 0 | 7936632 | 41395728 | 6 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|