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 | 2633 | 3255905677728 | 0 | 1236576264 | 260508146448 | 1320 | 26738688 | 20256.5818 | 921 | 38780928 | 42107.4137 | 65519616 | |
sql/io_cache | 136 | 4897573824 | 0 | 36011448 | 1337204880 | 60 | 3414672 | 56911.2000 | 56 | 3414672 | 60976.2857 | 6829344 | |
innodb/innodb_temp_file | 230 | 812301413088 | 0 | 3531745272 | 123428167632 | 0 | 0 | 0.0000 | 153 | 4276224 | 27949.1765 | 4276224 | |
sql/ERRMSG | 65 | 40831776480 | 3380784 | 628181136 | 6309667056 | 39 | 3990760 | 102327.1795 | 0 | 0 | 0.0000 | 3990760 | |
innodb/innodb_log_file | 657 | 4570627290768 | 236016 | 6956814744 | 632450985408 | 8 | 70656 | 8832.0000 | 383 | 365568 | 954.4856 | 436224 | |
mysys/charset | 3 | 311573328 | 3345936 | 103857600 | 293156688 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 308 | 132501509184 | 0 | 430199616 | 22942840272 | 72 | 1031 | 14.3194 | 8 | 1520 | 190.0000 | 2551 | |
sql/binlog_index | 38 | 46046909568 | 0 | 1211760528 | 23730568224 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 2002579920 | 376992 | 400515984 | 1980682704 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 777155808 | 834768 | 194288952 | 628260336 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 54442080 | 2813184 | 18147360 | 35740848 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 835168224 | 0 | 55677864 | 767201952 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 697420944 | 0 | 232473648 | 671479248 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 17694864 | 0 | 8847432 | 11169312 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|