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 | 2960 | 4656898836480 | 0 | 1573276584 | 281476249824 | 1319 | 26722304 | 20259.5178 | 1135 | 45367296 | 39971.1859 | 72089600 | |
innodb/innodb_temp_file | 337 | 1844339284656 | 0 | 5472816624 | 70792858224 | 0 | 0 | 0.0000 | 220 | 7995392 | 36342.6909 | 7995392 | |
sql/io_cache | 102 | 7145616192 | 0 | 70055040 | 4082422080 | 42 | 2355216 | 56076.5714 | 40 | 2355216 | 58880.4000 | 4710432 | |
sql/ERRMSG | 65 | 45420190464 | 2755632 | 698772096 | 9278350752 | 39 | 3990930 | 102331.5385 | 0 | 0 | 0.0000 | 3990930 | |
innodb/innodb_log_file | 964 | 5820157448160 | 227568 | 6037507608 | 117169285200 | 8 | 70656 | 8832.0000 | 568 | 567296 | 998.7606 | 637952 | |
mysys/charset | 3 | 341592240 | 2270400 | 113863992 | 319848144 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 661 | 415969682832 | 0 | 629303400 | 26435003760 | 150 | 1196 | 7.9733 | 27 | 7689 | 284.7778 | 8885 | |
myisam/dfile | 80 | 224526720 | 93984 | 2806584 | 193025712 | 50 | 2973 | 59.4600 | 0 | 0 | 0.0000 | 2973 | |
myisam/kfile | 4 | 711884448 | 843216 | 177971112 | 684324432 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 82209040320 | 0 | 2163395784 | 53063484144 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 14342219232 | 244464 | 2868443688 | 14322375936 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 661642608 | 663696 | 165410520 | 601390416 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 24521904 | 780912 | 8173968 | 17727600 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 967200432 | 0 | 64479888 | 881860320 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 6 | 2514257856 | 0 | 419042976 | 1819110480 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 9 | 485444784 | 0 | 53938104 | 266227104 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|