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 | 2897 | 2438063921040 | 0 | 841582104 | 221116210128 | 1231 | 25280512 | 20536.5654 | 1360 | 53264384 | 39164.9882 | 78544896 | |
sql/ERRMSG | 40 | 20196644688 | 3523344 | 504916104 | 3199107648 | 24 | 2465379 | 102724.1250 | 0 | 0 | 0.0000 | 2465379 | |
innodb/innodb_temp_file | 93 | 377792642304 | 0 | 4062286272 | 28676036400 | 0 | 0 | 0.0000 | 32 | 1245184 | 38912.0000 | 1245184 | |
innodb/innodb_log_file | 987 | 5147891988096 | 227040 | 5215695936 | 134007513024 | 8 | 70656 | 8832.0000 | 603 | 477696 | 792.1990 | 548352 | |
mysys/charset | 3 | 259097520 | 3311616 | 86365752 | 240466512 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 182 | 39706869840 | 0 | 218169600 | 19374493776 | 43 | 915 | 21.2791 | 3 | 156 | 52.0000 | 1071 | |
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 | 1 | 8980224 | 0 | 8980224 | 8980224 | 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 |
|