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 | 2275 | 1345042604928 | 0 | 591227472 | 212227573008 | 1362 | 27426816 | 20137.1630 | 618 | 29736960 | 48118.0583 | 57163776 | |
sql/ERRMSG | 35 | 54521250960 | 2694384 | 1557749952 | 24960319824 | 21 | 2158912 | 102805.3333 | 0 | 0 | 0.0000 | 2158912 | |
innodb/innodb_temp_file | 102 | 407853906240 | 0 | 3998567496 | 35346622080 | 0 | 0 | 0.0000 | 38 | 1540096 | 40528.8421 | 1540096 | |
innodb/innodb_log_file | 504 | 2669005117152 | 239712 | 5295644904 | 150927402384 | 8 | 70656 | 8832.0000 | 300 | 257536 | 858.4533 | 328192 | |
mysys/charset | 3 | 358809792 | 2439360 | 119603088 | 329934528 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 69 | 35662966416 | 0 | 516854448 | 15920828880 | 14 | 652 | 46.5714 | 3 | 156 | 52.0000 | 808 | |
myisam/kfile | 4 | 654745872 | 1316304 | 163686336 | 633151728 | 2 | 392 | 196.0000 | 0 | 0 | 0.0000 | 392 | |
sql/binlog_index | 38 | 42042741840 | 0 | 1106387832 | 25254459648 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 573747504 | 155232 | 114749448 | 554517216 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 504854592 | 703296 | 126213648 | 408988800 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 18692256 | 1305744 | 6230664 | 13090176 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1508866656 | 0 | 100590864 | 1427685072 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 5328048 | 0 | 5328048 | 5328048 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 9 | 51525408 | 0 | 5724840 | 17335824 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 10081632 | 624096 | 5040816 | 9457536 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|