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 | 2620 | 2784030468912 | 0 | 1062606864 | 268286702112 | 1471 | 29212672 | 19859.0564 | 721 | 32292864 | 44788.9931 | 61505536 | |
sql/io_cache | 145 | 5021586240 | 0 | 34631520 | 979755744 | 48 | 3441568 | 71699.3333 | 62 | 3437194 | 55438.6129 | 6878762 | |
innodb/innodb_temp_file | 238 | 824800672080 | 0 | 3465548856 | 37171948176 | 0 | 0 | 0.0000 | 157 | 4603904 | 29324.2293 | 4603904 | |
sql/ERRMSG | 75 | 62890390992 | 2505360 | 838538448 | 6483969888 | 45 | 4600155 | 102225.6667 | 0 | 0 | 0.0000 | 4600155 | |
innodb/innodb_log_file | 574 | 3987722083488 | 228096 | 6947250816 | 833989824624 | 8 | 70656 | 8832.0000 | 337 | 280576 | 832.5697 | 351232 | |
mysys/charset | 3 | 224316048 | 2027520 | 74771928 | 209386320 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 453 | 77151851040 | 0 | 170313000 | 25338610176 | 109 | 1032 | 9.4679 | 5 | 661 | 132.2000 | 1693 | |
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 |
|