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 | 3281 | 4956365573280 | 0 | 1510626480 | 243183928416 | 1341 | 27082752 | 20195.9374 | 1358 | 54050816 | 39801.7791 | 81133568 | |
sql/ERRMSG | 65 | 41771325024 | 2901360 | 642635664 | 12375832128 | 39 | 3982377 | 102112.2308 | 0 | 0 | 0.0000 | 3982377 | |
innodb/innodb_log_file | 1990 | 11047952138256 | 221232 | 5551734672 | 873237203520 | 8 | 70656 | 8832.0000 | 1276 | 1830912 | 1434.8840 | 1901568 | |
innodb/innodb_temp_file | 98 | 429155361360 | 0 | 4379136168 | 31143157584 | 0 | 0 | 0.0000 | 35 | 1425408 | 40725.9429 | 1425408 | |
sql/binlog | 183 | 613691904144 | 0 | 3353507520 | 41839874736 | 22 | 684 | 31.0909 | 44 | 18947 | 430.6136 | 19631 | |
mysys/charset | 3 | 236616336 | 1373856 | 78872112 | 226064256 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog_index | 38 | 55260657408 | 0 | 1454227632 | 31897800000 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 693462528 | 339504 | 138692400 | 670223136 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 397199088 | 658416 | 99299640 | 336513408 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 47994672 | 2456784 | 15998136 | 37599936 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 772857888 | 0 | 51523824 | 710686416 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 6 | 77953920 | 0 | 12992232 | 19904544 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 221022384 | 0 | 110511192 | 214909728 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|