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 | 2678 | 2951437598736 | 0 | 1102104960 | 223074797616 | 1307 | 26525696 | 20295.1002 | 1023 | 42090496 | 41144.1799 | 68616192 | |
innodb/innodb_temp_file | 228 | 1117863262560 | 0 | 4902909000 | 54622378800 | 0 | 0 | 0.0000 | 133 | 5128192 | 38557.8346 | 5128192 | |
sql/ERRMSG | 55 | 30612479040 | 2689632 | 556590408 | 2116245648 | 33 | 3381351 | 102465.1818 | 0 | 0 | 0.0000 | 3381351 | |
innodb/innodb_log_file | 791 | 4437624952464 | 229680 | 5610145200 | 111088269072 | 8 | 70656 | 8832.0000 | 467 | 407552 | 872.7024 | 478208 | |
mysys/charset | 3 | 234933072 | 1822656 | 78310848 | 221570976 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 293 | 123260503344 | 0 | 420684264 | 16762243872 | 67 | 864 | 12.8955 | 9 | 1786 | 198.4444 | 2650 | |
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 | 5 | 75008208 | 0 | 15001536 | 19650576 | 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 |
|