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 | 2553 | 3498392909616 | 0 | 1370306520 | 281476249824 | 1312 | 26607616 | 20280.1951 | 828 | 35667968 | 43077.2560 | 62275584 | |
innodb/innodb_temp_file | 272 | 1542950650032 | 0 | 5672612616 | 39085644576 | 0 | 0 | 0.0000 | 165 | 6438912 | 39023.7091 | 6438912 | |
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 | 698 | 4275152543376 | 227568 | 6124860192 | 117169285200 | 8 | 70656 | 8832.0000 | 407 | 381440 | 937.1990 | 452096 | |
mysys/charset | 3 | 341592240 | 2270400 | 113863992 | 319848144 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 497 | 148936800144 | 0 | 299671416 | 26435003760 | 118 | 1068 | 9.0508 | 9 | 1956 | 217.3333 | 3024 | |
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 |
|