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 | 2538 | 3428941935936 | 0 | 1351040856 | 281476249824 | 1312 | 26607616 | 20280.1951 | 818 | 35373056 | 43243.3447 | 61980672 | |
innodb/innodb_temp_file | 264 | 1496184772368 | 0 | 5667366408 | 39085644576 | 0 | 0 | 0.0000 | 160 | 6160384 | 38502.4000 | 6160384 | |
sql/ERRMSG | 65 | 45420190464 | 2755632 | 698772096 | 9278350752 | 39 | 3990930 | 102331.5385 | 0 | 0 | 0.0000 | 3990930 | |
sql/io_cache | 34 | 1499486736 | 0 | 44102520 | 719918496 | 10 | 783972 | 78397.2000 | 14 | 783972 | 55998.0000 | 1567944 | |
innodb/innodb_log_file | 685 | 4183868364720 | 227568 | 6107836944 | 117169285200 | 8 | 70656 | 8832.0000 | 400 | 377856 | 944.6400 | 448512 | |
mysys/charset | 3 | 341592240 | 2270400 | 113863992 | 319848144 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 485 | 148862855328 | 0 | 306933528 | 26435003760 | 115 | 1056 | 9.1826 | 9 | 1956 | 217.3333 | 3012 | |
sql/binlog_index | 38 | 82209040320 | 0 | 2163395784 | 53063484144 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 14342219232 | 244464 | 2868443688 | 14322375936 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 661642608 | 663696 | 165410520 | 601390416 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 24521904 | 780912 | 8173968 | 17727600 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 967200432 | 0 | 64479888 | 881860320 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 5 | 695147376 | 0 | 139029264 | 453302256 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 190163424 | 0 | 95081712 | 179878512 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|