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 | 1450 | 331728355200 | 0 | 228778176 | 116131148496 | 701 | 33884246 | 48337.0128 | 579 | 33875498 | 58506.9050 | 67759744 | |
innodb/innodb_data_file | 3019 | 3488182875936 | 0 | 1155409992 | 255763744368 | 1613 | 31539200 | 19553.1308 | 855 | 36192256 | 42330.1240 | 67731456 | |
innodb/innodb_temp_file | 727 | 1897782790992 | 0 | 2610430152 | 572865222864 | 0 | 0 | 0.0000 | 629 | 13451264 | 21385.1574 | 13451264 | |
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 | 769 | 4462610689680 | 232848 | 5803134744 | 96851922816 | 8 | 70656 | 8832.0000 | 437 | 337920 | 773.2723 | 408576 | |
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 | 861 | 59547341040 | 0 | 69160608 | 33895667520 | 212 | 1444 | 6.8113 | 3 | 156 | 52.0000 | 1600 | |
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 |
|