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 | 4349 | 4332050379360 | 0 | 996102624 | 221116210128 | 1258 | 25722880 | 20447.4404 | 2612 | 92749824 | 35509.1210 | 118472704 | |
sql/ERRMSG | 50 | 23578305696 | 3523344 | 471566040 | 3199107648 | 30 | 3074631 | 102487.7000 | 0 | 0 | 0.0000 | 3074631 | |
innodb/innodb_temp_file | 93 | 377792642304 | 0 | 4062286272 | 28676036400 | 0 | 0 | 0.0000 | 32 | 1245184 | 38912.0000 | 1245184 | |
innodb/innodb_log_file | 1973 | 10183145765760 | 227040 | 5161249632 | 134007513024 | 8 | 70656 | 8832.0000 | 1202 | 920576 | 765.8702 | 991232 | |
mysys/charset | 3 | 259097520 | 3311616 | 86365752 | 240466512 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 288 | 53948953344 | 0 | 187322520 | 19374493776 | 69 | 1019 | 14.7681 | 4 | 414 | 103.5000 | 1433 | |
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 |
|