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 | 2995 | 3161938519872 | 0 | 1055738904 | 224570539248 | 1489 | 29507584 | 19817.0477 | 1052 | 42647552 | 40539.4981 | 72155136 | |
sql/io_cache | 444 | 36684587808 | 0 | 82622760 | 15745989072 | 178 | 10696788 | 60094.3146 | 186 | 10696788 | 57509.6129 | 21393576 | |
innodb/innodb_temp_file | 324 | 712148383056 | 0 | 2197988760 | 37811261136 | 0 | 0 | 0.0000 | 246 | 5865472 | 23843.3821 | 5865472 | |
sql/ERRMSG | 60 | 32851836864 | 2375472 | 547530456 | 2189803440 | 36 | 3680526 | 102236.8333 | 0 | 0 | 0.0000 | 3680526 | |
innodb/innodb_log_file | 882 | 4822377294240 | 371712 | 5467547712 | 162283831248 | 8 | 70656 | 8832.0000 | 519 | 419328 | 807.9538 | 489984 | |
mysys/charset | 3 | 332358048 | 2283600 | 110786016 | 318021264 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 209 | 45373592880 | 0 | 217098288 | 19488955728 | 49 | 792 | 16.1633 | 3 | 156 | 52.0000 | 948 | |
myisam/kfile | 4 | 525265488 | 572352 | 131316240 | 505851984 | 2 | 462 | 231.0000 | 0 | 0 | 0.0000 | 462 | |
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 | 8 | 414571872 | 0 | 51821352 | 340529376 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 9267984 | 321552 | 4633992 | 8946432 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|