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 | 4019 | 4792647253680 | 0 | 1192497240 | 224570539248 | 1650 | 32145408 | 19482.0655 | 1726 | 63488000 | 36783.3140 | 95633408 | |
sql/io_cache | 996 | 45164779968 | 0 | 45345960 | 15745989072 | 456 | 23425408 | 51371.5088 | 400 | 23425408 | 58563.5200 | 46850816 | |
innodb/innodb_temp_file | 725 | 1318021882320 | 0 | 1817961024 | 210583685136 | 0 | 0 | 0.0000 | 624 | 13565952 | 21740.3077 | 13565952 | |
sql/ERRMSG | 70 | 38797153296 | 2375472 | 554245032 | 2189803440 | 42 | 4295627 | 102276.8333 | 0 | 0 | 0.0000 | 4295627 | |
innodb/innodb_log_file | 1426 | 7615763916816 | 371712 | 5340647664 | 162283831248 | 8 | 70656 | 8832.0000 | 842 | 648192 | 769.8242 | 718848 | |
mysys/charset | 3 | 332358048 | 2283600 | 110786016 | 318021264 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/kfile | 16 | 1995569136 | 572352 | 124722840 | 601094736 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
sql/binlog | 429 | 47130692928 | 0 | 109861752 | 19488955728 | 104 | 1012 | 9.7308 | 3 | 156 | 52.0000 | 1168 | |
sql/binlog_index | 38 | 54826658304 | 0 | 1442806728 | 33632951088 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2268563088 | 756624 | 283570320 | 1225922016 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 2969337888 | 371184 | 593867472 | 2936046432 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 59897376 | 3059760 | 19965792 | 49323120 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1127330688 | 0 | 75155256 | 1065339792 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 13021008 | 0 | 13021008 | 13021008 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 13 | 453690336 | 0 | 34899216 | 340529376 | 4 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 9 | 87269952 | 301488 | 9696456 | 29321952 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|