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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sql/io_cache | 1791 | 195933911712 | 0 | 109398960 | 33372872016 | 818 | 41422422 | 50638.6577 | 713 | 41348064 | 57991.6746 | 82770486 | |
innodb/innodb_data_file | 2991 | 4001350077648 | 0 | 1337796504 | 258246555072 | 1513 | 29900800 | 19762.5909 | 985 | 40353792 | 40968.3168 | 70254592 | |
innodb/innodb_temp_file | 856 | 2477243149392 | 0 | 2893975392 | 394185231264 | 0 | 0 | 0.0000 | 731 | 16891904 | 23107.9398 | 16891904 | |
sql/ERRMSG | 80 | 70230804864 | 3753024 | 877885008 | 3930366000 | 48 | 4912652 | 102346.9167 | 0 | 0 | 0.0000 | 4912652 | |
innodb/innodb_log_file | 780 | 4828733738400 | 230208 | 6190684104 | 106825795296 | 8 | 70656 | 8832.0000 | 449 | 422912 | 941.8976 | 493568 | |
mysys/charset | 3 | 275608080 | 3404016 | 91869360 | 252613152 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 857 | 377164803312 | 0 | 440098824 | 220899293472 | 209 | 1726 | 8.2584 | 10 | 2190 | 219.0000 | 3916 | |
myisam/kfile | 4 | 238816512 | 732864 | 59704128 | 221529264 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 62476060944 | 0 | 1644106728 | 30830712528 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1877252784 | 664752 | 234656400 | 786369936 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 948244704 | 149424 | 189648888 | 932293296 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 54952656 | 2823744 | 18317376 | 33554400 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 799340256 | 0 | 53289192 | 713658000 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 5 | 53131056 | 0 | 10626000 | 13691040 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 763434672 | 0 | 190858536 | 662017488 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 7512912 | 298320 | 3756456 | 7214592 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|