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 | 2584 | 1974748342512 | 0 | 764221392 | 193056931056 | 1537 | 30441472 | 19805.7723 | 706 | 32063488 | 45415.7054 | 62504960 | |
sql/io_cache | 502 | 134968029504 | 0 | 268860504 | 87974837280 | 240 | 12293644 | 51223.5167 | 202 | 12293644 | 60859.6238 | 24587288 | |
innodb/innodb_temp_file | 599 | 793776721056 | 0 | 1325169648 | 63615470688 | 0 | 0 | 0.0000 | 515 | 10665984 | 20710.6485 | 10665984 | |
sql/ERRMSG | 80 | 44735958960 | 2296800 | 559199256 | 2956286256 | 48 | 4913439 | 102363.3125 | 0 | 0 | 0.0000 | 4913439 | |
innodb/innodb_log_file | 578 | 3036256152336 | 229152 | 5253038208 | 38965115904 | 8 | 70656 | 8832.0000 | 339 | 286208 | 844.2714 | 356864 | |
mysys/charset | 3 | 255759504 | 2169024 | 85252992 | 243990912 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 305 | 127259664576 | 0 | 417244608 | 20802262272 | 72 | 7403 | 102.8194 | 8 | 1727 | 215.8750 | 9130 | |
sql/binlog_index | 23 | 1687327488 | 0 | 73361904 | 426533184 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | 160 | |
mysys/cnf | 5 | 167694384 | 215424 | 33538824 | 152746176 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 26642880 | 1858032 | 8880960 | 20526000 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1153361616 | 0 | 76890528 | 1088362176 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 57339216 | 0 | 19113072 | 30623472 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|