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 | 2293 | 2236440801936 | 0 | 975333744 | 264024407328 | 1365 | 27475968 | 20128.9143 | 636 | 30294016 | 47632.1006 | 57769984 | |
sql/ERRMSG | 40 | 18294981936 | 2510112 | 457374456 | 2538897504 | 24 | 2458173 | 102423.8750 | 0 | 0 | 0.0000 | 2458173 | |
innodb/innodb_temp_file | 117 | 516288078240 | 0 | 4412718552 | 25413330624 | 0 | 0 | 0.0000 | 49 | 1982464 | 40458.4490 | 1982464 | |
innodb/innodb_log_file | 514 | 3050177456832 | 237600 | 5934197280 | 212821987488 | 8 | 70656 | 8832.0000 | 305 | 295424 | 968.6033 | 366080 | |
mysys/charset | 3 | 228560640 | 2232912 | 76186704 | 214938240 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 159 | 265549641456 | 0 | 1670123400 | 17505623520 | 27 | 704 | 26.0741 | 22 | 5957 | 270.7727 | 6661 | |
sql/binlog_index | 38 | 60573022752 | 0 | 1594026720 | 40847173488 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 13819332384 | 1877040 | 1727416416 | 12210742896 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1260207696 | 273504 | 252041328 | 1235320944 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 58526160 | 3426720 | 19508544 | 37677552 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1055232816 | 0 | 70348608 | 979285824 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 62546880 | 0 | 15636720 | 28902720 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 759316272 | 0 | 189828936 | 654167184 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|