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 | 3331 | 6021885483504 | 0 | 1807831080 | 413285867808 | 1499 | 29671424 | 19794.1454 | 1206 | 46645248 | 38677.6517 | 76316672 | |
innodb/innodb_temp_file | 260 | 1646831848464 | 0 | 6333968520 | 53681772144 | 0 | 0 | 0.0000 | 141 | 6832128 | 48454.8085 | 6832128 | |
sql/ERRMSG | 90 | 70342911936 | 3744576 | 781587840 | 6191760960 | 54 | 5523665 | 102290.0926 | 0 | 0 | 0.0000 | 5523665 | |
innodb/innodb_log_file | 1079 | 6637865016288 | 222288 | 6151867392 | 118050135984 | 8 | 70656 | 8832.0000 | 627 | 585728 | 934.1754 | 656384 | |
mysys/charset | 3 | 249918240 | 2520672 | 83305992 | 231182160 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 959 | 695986745520 | 0 | 725742072 | 33240542544 | 216 | 1460 | 6.7593 | 44 | 11322 | 257.3182 | 12782 | |
myisam/kfile | 8 | 1020285024 | 601920 | 127535496 | 656268624 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | 834 | |
sql/binlog_index | 38 | 66260416464 | 0 | 1743694920 | 35990128416 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 779130000 | 458304 | 97391184 | 406628112 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
myisam/dfile | 8 | 1611045216 | 342144 | 201380520 | 1566129312 | 1 | 67 | 67.0000 | 0 | 0 | 0.0000 | 67 | |
mysys/cnf | 5 | 1305786240 | 305712 | 261157248 | 1276569888 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 48375360 | 2816352 | 16125120 | 38416752 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 766114800 | 0 | 51074232 | 688226880 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 17 | 302719296 | 0 | 17806800 | 32271360 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 257541504 | 0 | 64385376 | 228169920 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|