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 | 3217 | 3712363456560 | 0 | 1153982808 | 280833414048 | 1526 | 30113792 | 19733.8087 | 1175 | 46809088 | 39837.5217 | 76922880 | |
sql/io_cache | 316 | 31617779952 | 0 | 100056264 | 12368778048 | 140 | 7153184 | 51094.1714 | 126 | 7135688 | 56632.4444 | 14288872 | |
innodb/innodb_temp_file | 140 | 706469942112 | 0 | 5046213744 | 30527282016 | 0 | 0 | 0.0000 | 64 | 2752512 | 43008.0000 | 2752512 | |
sql/ERRMSG | 40 | 30022499232 | 2172720 | 750562296 | 3160834512 | 24 | 2458253 | 102427.2083 | 0 | 0 | 0.0000 | 2458253 | |
innodb/innodb_log_file | 1043 | 6592881574752 | 236016 | 6321075288 | 236695016976 | 8 | 70656 | 8832.0000 | 620 | 528896 | 853.0581 | 599552 | |
mysys/charset | 3 | 220453200 | 2676960 | 73484400 | 207394704 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 164 | 167365303248 | 0 | 1020519984 | 23802497136 | 34 | 879 | 25.8529 | 12 | 2777 | 231.4167 | 3656 | |
myisam/kfile | 16 | 2067857616 | 595584 | 129240936 | 666072528 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
myisam/dfile | 41 | 587142864 | 188496 | 14320416 | 498050784 | 25 | 975 | 39.0000 | 0 | 0 | 0.0000 | 975 | |
sql/binlog_index | 38 | 55129757760 | 0 | 1450782960 | 31105839600 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 5245216944 | 651024 | 655651920 | 2329957344 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 640996752 | 159984 | 128199192 | 623298192 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 47003088 | 2814240 | 15667608 | 37419888 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1167599664 | 0 | 77839872 | 1108615728 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 28188336 | 0 | 9396024 | 14286624 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 42 | 981044592 | 0 | 23358192 | 489782304 | 16 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|