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 | 2451 | 2297291439168 | 0 | 937287384 | 224570539248 | 1382 | 27754496 | 20082.8480 | 717 | 32358400 | 45130.2650 | 60112896 | |
sql/io_cache | 178 | 30077492544 | 0 | 168974520 | 15745989072 | 76 | 4257638 | 56021.5526 | 72 | 4257638 | 59133.8611 | 8515276 | |
innodb/innodb_temp_file | 275 | 449865309696 | 0 | 1635873624 | 37811261136 | 0 | 0 | 0.0000 | 212 | 4325376 | 20402.7170 | 4325376 | |
sql/ERRMSG | 50 | 27469075392 | 2375472 | 549381360 | 2189803440 | 30 | 3068702 | 102290.0667 | 0 | 0 | 0.0000 | 3068702 | |
innodb/innodb_log_file | 567 | 3112636422720 | 371712 | 5489658504 | 162283831248 | 8 | 70656 | 8832.0000 | 333 | 281088 | 844.1081 | 351744 | |
mysys/charset | 3 | 332358048 | 2283600 | 110786016 | 318021264 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 153 | 45087543600 | 0 | 294689736 | 19488955728 | 35 | 736 | 21.0286 | 3 | 156 | 52.0000 | 892 | |
sql/binlog_index | 38 | 54826658304 | 0 | 1442806728 | 33632951088 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 2969337888 | 371184 | 593867472 | 2936046432 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 1630236432 | 1924032 | 407558976 | 1225922016 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
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 | 2 | 42926400 | 0 | 21463200 | 30791376 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|