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 | 2517 | 2323201382832 | 0 | 923003928 | 268286702112 | 1465 | 29114368 | 19873.2887 | 666 | 30785536 | 46224.5285 | 59899904 | |
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 | 498 | 3509951410416 | 228096 | 7048095120 | 833989824624 | 8 | 70656 | 8832.0000 | 295 | 250880 | 850.4407 | 321536 | |
mysys/charset | 3 | 224316048 | 2027520 | 74771928 | 209386320 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 285 | 76276244880 | 0 | 267635808 | 25338610176 | 67 | 864 | 12.8955 | 5 | 661 | 132.2000 | 1525 | |
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 |
|