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 | 2560 | 2535447689808 | 0 | 990409200 | 268286702112 | 1465 | 29114368 | 19873.2887 | 691 | 31473664 | 45547.9942 | 60588032 | |
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 | 232 | 787937719536 | 0 | 3396283176 | 37171948176 | 0 | 0 | 0.0000 | 153 | 4407296 | 28805.8562 | 4407296 | |
innodb/innodb_log_file | 533 | 3706654212624 | 228096 | 6954322848 | 833989824624 | 8 | 70656 | 8832.0000 | 314 | 260608 | 829.9618 | 331264 | |
mysys/charset | 3 | 224316048 | 2027520 | 74771928 | 209386320 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 401 | 76884249552 | 0 | 191731056 | 25338610176 | 96 | 980 | 10.2083 | 5 | 661 | 132.2000 | 1641 | |
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 |
|