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 | 2796 | 3063471558576 | 0 | 1095662040 | 231016347936 | 1528 | 30146560 | 19729.4241 | 828 | 35733504 | 43156.4058 | 65880064 | |
sql/io_cache | 102 | 5742365904 | 0 | 56297472 | 2871303072 | 54 | 2354804 | 43607.4815 | 38 | 2354804 | 61968.5263 | 4709608 | |
sql/ERRMSG | 65 | 27540242928 | 2595120 | 423695976 | 2096129376 | 39 | 3998952 | 102537.2308 | 0 | 0 | 0.0000 | 3998952 | |
innodb/innodb_temp_file | 211 | 622316150544 | 0 | 2949365496 | 38759828448 | 0 | 0 | 0.0000 | 150 | 3178496 | 21189.9733 | 3178496 | |
innodb/innodb_log_file | 684 | 4791614257584 | 240768 | 7005283824 | 559216915488 | 8 | 70656 | 8832.0000 | 399 | 334848 | 839.2180 | 405504 | |
mysys/charset | 3 | 276754368 | 2310528 | 92251368 | 263060688 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 385 | 151614054240 | 0 | 393802728 | 23606213664 | 90 | 956 | 10.6222 | 9 | 1618 | 179.7778 | 2574 | |
myisam/kfile | 4 | 2968414416 | 1213344 | 742103472 | 2939261424 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 50968617216 | 0 | 1341279192 | 30236983392 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 744420336 | 508992 | 93052344 | 347946192 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 329248656 | 205920 | 65849520 | 311922864 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 50420304 | 2930928 | 16806768 | 39517104 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 712601472 | 0 | 47506536 | 649463760 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 5 | 83666352 | 0 | 16733112 | 27613344 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 198556512 | 0 | 49639128 | 150750864 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 19801584 | 880704 | 9900792 | 18920880 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|