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 | 2551 | 2492971301040 | 0 | 977252496 | 268286702112 | 1465 | 29114368 | 19873.2887 | 686 | 31342592 | 45688.9096 | 60456960 | |
sql/io_cache | 145 | 5021586240 | 0 | 34631520 | 979755744 | 48 | 3441568 | 71699.3333 | 62 | 3437194 | 55438.6129 | 6878762 | |
sql/ERRMSG | 75 | 62890390992 | 2505360 | 838538448 | 6483969888 | 45 | 4600155 | 102225.6667 | 0 | 0 | 0.0000 | 4600155 | |
innodb/innodb_temp_file | 220 | 710852312016 | 0 | 3231146688 | 37171948176 | 0 | 0 | 0.0000 | 145 | 4014080 | 27683.3103 | 4014080 | |
innodb/innodb_log_file | 526 | 3657804009552 | 228096 | 6953999976 | 833989824624 | 8 | 70656 | 8832.0000 | 310 | 258560 | 834.0645 | 329216 | |
mysys/charset | 3 | 224316048 | 2027520 | 74771928 | 209386320 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 301 | 76356067920 | 0 | 253674432 | 25338610176 | 71 | 880 | 12.3944 | 5 | 661 | 132.2000 | 1541 | |
myisam/kfile | 8 | 572829840 | 665808 | 71603664 | 295258656 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | 834 | |
sql/binlog_index | 38 | 57875521968 | 0 | 1523040024 | 36582193824 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 5237149104 | 155760 | 1047429768 | 5217673824 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 18030672 | 719136 | 6010224 | 12366816 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1146586320 | 0 | 76439088 | 1080964368 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 65041680 | 0 | 21680472 | 40807536 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 6 | 26837712 | 321552 | 4472952 | 9167136 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|