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 | 1723 | 1327449485472 | 0 | 770429088 | 213452401008 | 1253 | 25640960 | 20463.6552 | 261 | 18268160 | 69992.9502 | 43909120 | |
sql/io_cache | 126 | 5868575856 | 0 | 46575936 | 1751307888 | 40 | 3080824 | 77020.6000 | 56 | 3080824 | 55014.7143 | 6161648 | |
innodb/innodb_temp_file | 185 | 441532440624 | 0 | 2386661640 | 27530831328 | 0 | 0 | 0.0000 | 122 | 2850816 | 23367.3443 | 2850816 | |
sql/ERRMSG | 40 | 73930660320 | 3183840 | 1848266376 | 36312460272 | 24 | 2458410 | 102433.7500 | 0 | 0 | 0.0000 | 2458410 | |
innodb/innodb_log_file | 205 | 2599231014864 | 236544 | 12679175520 | 777980656992 | 8 | 70656 | 8832.0000 | 114 | 109568 | 961.1228 | 180224 | |
mysys/charset | 3 | 275331936 | 2090352 | 91777224 | 262958784 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 57 | 36269353296 | 0 | 636304416 | 20979488640 | 11 | 640 | 58.1818 | 3 | 156 | 52.0000 | 796 | |
sql/binlog_index | 38 | 46944059712 | 0 | 1235369784 | 28230714864 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 640564848 | 172656 | 128112864 | 623886912 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 16392288 | 794112 | 5464008 | 13366320 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 734937984 | 0 | 48995760 | 661497936 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 10514592 | 0 | 10514592 | 10514592 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|