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 | 2148 | 1540235148672 | 0 | 717055416 | 244004240832 | 1331 | 26918912 | 20224.5770 | 553 | 27475968 | 49685.2948 | 54394880 | |
sql/io_cache | 446 | 221629344816 | 0 | 496926672 | 130012664496 | 162 | 10434696 | 64411.7037 | 184 | 10434696 | 56710.3043 | 20869392 | |
innodb/innodb_temp_file | 719 | 1082013555216 | 0 | 1504886592 | 137233295232 | 0 | 0 | 0.0000 | 648 | 11993088 | 18507.8519 | 11993088 | |
sql/ERRMSG | 70 | 49856402112 | 2535984 | 712234248 | 4138246992 | 42 | 4294010 | 102238.3333 | 0 | 0 | 0.0000 | 4294010 | |
innodb/innodb_log_file | 394 | 1940846060736 | 221232 | 4926005040 | 38391000384 | 8 | 70656 | 8832.0000 | 230 | 206336 | 897.1130 | 276992 | |
mysys/charset | 3 | 232428240 | 1462032 | 77476080 | 220087824 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 269 | 42198453264 | 0 | 156871440 | 18097732752 | 64 | 852 | 13.3125 | 3 | 156 | 52.0000 | 1008 | |
myisam/kfile | 8 | 497683296 | 736032 | 62210280 | 316415616 | 4 | 799 | 199.7500 | 0 | 0 | 0.0000 | 799 | |
sql/binlog_index | 38 | 54758635008 | 0 | 1441016544 | 35476338480 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 597839616 | 807312 | 74729952 | 213132480 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 669871488 | 136752 | 133974192 | 652047792 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 46719024 | 2764608 | 15572832 | 37172784 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 961288944 | 0 | 64085736 | 898119552 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 12762816 | 0 | 12762816 | 12762816 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 9 | 548291040 | 0 | 60921168 | 243129744 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 21402480 | 330528 | 5350488 | 13371600 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|