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 | 5745 | 5945411081808 | 0 | 1034884224 | 221116210128 | 1266 | 25853952 | 20421.7630 | 3847 | 131809280 | 34262.8750 | 157663232 | |
sql/ERRMSG | 60 | 30881940144 | 3523344 | 514698888 | 3199107648 | 36 | 3685194 | 102366.5000 | 0 | 0 | 0.0000 | 3685194 | |
innodb/innodb_log_file | 2923 | 14795595272832 | 227040 | 5061784200 | 134007513024 | 8 | 70656 | 8832.0000 | 1782 | 1338880 | 751.3356 | 1409536 | |
innodb/innodb_temp_file | 93 | 377792642304 | 0 | 4062286272 | 28676036400 | 0 | 0 | 0.0000 | 32 | 1245184 | 38912.0000 | 1245184 | |
mysys/charset | 3 | 259097520 | 3311616 | 86365752 | 240466512 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 400 | 54521909904 | 0 | 136304520 | 19374493776 | 97 | 1131 | 11.6598 | 4 | 414 | 103.5000 | 1545 | |
sql/binlog_index | 38 | 52790407296 | 0 | 1389221064 | 29637031248 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1075628928 | 265056 | 215125680 | 1052486160 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 680796336 | 486816 | 170198952 | 552852960 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 48518976 | 2766192 | 16172904 | 37946304 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1022986800 | 0 | 68199120 | 918319248 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 19363344 | 0 | 9681672 | 10383120 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 14022096 | 0 | 7011048 | 9120672 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|