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 | 1626 | 903316577856 | 0 | 555545232 | 245722290528 | 1201 | 24788992 | 20640.2931 | 223 | 17121280 | 76777.0404 | 41910272 | |
innodb/innodb_temp_file | 90 | 374953519776 | 0 | 4166150208 | 37077346944 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | 1146880 | |
sql/ERRMSG | 15 | 8782417776 | 2801568 | 585494448 | 3771919008 | 9 | 913582 | 101509.1111 | 0 | 0 | 0.0000 | 913582 | |
innodb/innodb_log_file | 127 | 721517474832 | 289872 | 5681239872 | 68441111376 | 8 | 70656 | 8832.0000 | 68 | 79360 | 1167.0588 | 150016 | |
mysys/charset | 3 | 312624048 | 1823712 | 104207928 | 296586048 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 53 | 34349331984 | 0 | 648100464 | 17218169760 | 10 | 636 | 63.6000 | 3 | 156 | 52.0000 | 792 | |
sql/binlog_index | 38 | 58707549120 | 0 | 1544935392 | 35885627184 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 650229888 | 154704 | 130045872 | 632027088 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 50309952 | 2837472 | 16769808 | 39431040 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1118989344 | 0 | 74599272 | 1060058736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 13777104 | 0 | 13777104 | 13777104 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|