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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sql/io_cache | 1560 | 335247545424 | 0 | 214902072 | 116131148496 | 759 | 36404010 | 47963.1225 | 621 | 36395262 | 58607.5072 | 72799272 | |
innodb/innodb_data_file | 3052 | 3599428374960 | 0 | 1179366936 | 255763744368 | 1613 | 31539200 | 19553.1308 | 879 | 36913152 | 41994.4846 | 68452352 | |
innodb/innodb_temp_file | 742 | 1966796721120 | 0 | 2650669296 | 572865222864 | 0 | 0 | 0.0000 | 641 | 13844480 | 21598.2527 | 13844480 | |
sql/ERRMSG | 65 | 40737297744 | 2671680 | 626727552 | 2312179584 | 39 | 3987688 | 102248.4103 | 0 | 0 | 0.0000 | 3987688 | |
myisam/dfile | 8311 | 6406971648 | 78672 | 770880 | 1206482640 | 7302 | 492896 | 67.5015 | 0 | 0 | 0.0000 | 492896 | |
innodb/innodb_log_file | 778 | 4515573038064 | 232848 | 5804078280 | 96851922816 | 8 | 70656 | 8832.0000 | 442 | 340480 | 770.3167 | 411136 | |
mysys/charset | 3 | 293225328 | 2303136 | 97741776 | 276990384 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/kfile | 16 | 2916295536 | 774048 | 182268240 | 1360588416 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
sql/binlog | 873 | 59614673184 | 0 | 68287032 | 33895667520 | 215 | 1456 | 6.7721 | 3 | 156 | 52.0000 | 1612 | |
sql/binlog_index | 38 | 49923225264 | 0 | 1313769072 | 30804492576 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 643639920 | 577104 | 80454792 | 262093392 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1244412048 | 340560 | 248882304 | 1221739728 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 49250256 | 2774640 | 16416576 | 35327952 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 845012256 | 0 | 56333904 | 753700464 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 7064640 | 0 | 7064640 | 7064640 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 331878624 | 0 | 82969656 | 264547008 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|