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 | 2524 | 2332522766640 | 0 | 924137280 | 245722290528 | 1287 | 26198016 | 20355.8788 | 902 | 38387712 | 42558.4390 | 64585728 | |
sql/ERRMSG | 50 | 31510760688 | 2801568 | 630214992 | 3771919008 | 30 | 3075875 | 102529.1667 | 0 | 0 | 0.0000 | 3075875 | |
sql/io_cache | 56 | 1561558944 | 0 | 27884736 | 552694032 | 20 | 1468144 | 73407.2000 | 26 | 1468144 | 56467.0769 | 2936288 | |
innodb/innodb_temp_file | 139 | 1136126338512 | 0 | 8173570680 | 639797490288 | 0 | 0 | 0.0000 | 74 | 2195456 | 29668.3243 | 2195456 | |
innodb/innodb_log_file | 611 | 3466990798656 | 289872 | 5674289280 | 68441111376 | 8 | 70656 | 8832.0000 | 359 | 314368 | 875.6769 | 385024 | |
mysys/charset | 3 | 312624048 | 1823712 | 104207928 | 296586048 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 167 | 50620053792 | 0 | 303113976 | 17218169760 | 38 | 748 | 19.6842 | 4 | 394 | 98.5000 | 1142 | |
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 | |
csv/metadata | 4 | 396801504 | 757680 | 99200376 | 345324144 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
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 | 2 | 23485968 | 0 | 11742984 | 13777104 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 209211024 | 0 | 104605512 | 201041808 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|