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 | 2806 | 3340916491968 | 0 | 1190632872 | 223074797616 | 1324 | 26804224 | 20244.8822 | 1102 | 44449792 | 40335.5644 | 71254016 | |
innodb/innodb_temp_file | 240 | 1201284435120 | 0 | 5005351560 | 54622378800 | 0 | 0 | 0.0000 | 141 | 5521408 | 39158.9220 | 5521408 | |
sql/ERRMSG | 55 | 30612479040 | 2689632 | 556590408 | 2116245648 | 33 | 3381351 | 102465.1818 | 0 | 0 | 0.0000 | 3381351 | |
innodb/innodb_log_file | 906 | 5121200057952 | 229680 | 5652538584 | 111088269072 | 8 | 70656 | 8832.0000 | 535 | 451072 | 843.1252 | 521728 | |
mysys/charset | 3 | 234933072 | 1822656 | 78310848 | 221570976 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 347 | 145344304512 | 0 | 418859496 | 21200947152 | 80 | 916 | 11.4500 | 10 | 2024 | 202.4000 | 2940 | |
sql/binlog_index | 38 | 49367233872 | 0 | 1299137664 | 25897829760 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 939061728 | 572352 | 117382584 | 529160016 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1626003984 | 327888 | 325200744 | 1601333712 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 47110272 | 2697552 | 15703248 | 36738768 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 965857200 | 0 | 64390392 | 901338240 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 6 | 96675216 | 0 | 16112448 | 21667008 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 295831536 | 0 | 73957752 | 255767952 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|