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 | 2740 | 2456747083296 | 0 | 896622936 | 213977575680 | 1508 | 29818880 | 19773.7931 | 880 | 37601280 | 42728.7273 | 67420160 | |
innodb/innodb_temp_file | 223 | 1177087950192 | 0 | 5278421280 | 28980562512 | 0 | 0 | 0.0000 | 115 | 5685248 | 49436.9391 | 5685248 | |
sql/ERRMSG | 45 | 39262313904 | 3377088 | 872495712 | 8339011296 | 27 | 2771586 | 102651.3333 | 0 | 0 | 0.0000 | 2771586 | |
innodb/innodb_log_file | 679 | 3783035894352 | 210144 | 5571481344 | 105048285936 | 8 | 70656 | 8832.0000 | 401 | 331776 | 827.3716 | 402432 | |
mysys/charset | 3 | 269290032 | 2332704 | 89763168 | 248359584 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 1069 | 35803162560 | 0 | 33492096 | 16924607040 | 264 | 1652 | 6.2576 | 3 | 156 | 52.0000 | 1808 | |
myisam/kfile | 16 | 3556701456 | 550176 | 222293808 | 1646460816 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
myisam/dfile | 35 | 723416496 | 192720 | 20668824 | 625761312 | 25 | 975 | 39.0000 | 0 | 0 | 0.0000 | 975 | |
sql/binlog_index | 38 | 51186525456 | 0 | 1347013800 | 32652035856 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 3254152176 | 712800 | 406768824 | 2030030112 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 528715968 | 158400 | 105743088 | 510429216 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 16987872 | 638880 | 5662536 | 14624016 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 866684016 | 0 | 57778776 | 787952880 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 3210240 | 0 | 3210240 | 3210240 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 12 | 123645984 | 0 | 10303656 | 23561472 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|