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 | 1746 | 774079617168 | 0 | 443344440 | 196861435056 | 1273 | 25968640 | 20399.5601 | 283 | 19054592 | 67330.7138 | 45023232 | |
sql/ERRMSG | 50 | 214996207008 | 2265120 | 4299924024 | 189943456032 | 30 | 3068667 | 102288.9000 | 0 | 0 | 0.0000 | 3068667 | |
innodb/innodb_temp_file | 117 | 549786874560 | 0 | 4699032888 | 31571800128 | 0 | 0 | 0.0000 | 46 | 2129920 | 46302.6087 | 2129920 | |
innodb/innodb_log_file | 215 | 1475913202896 | 248160 | 6864712536 | 249228639792 | 8 | 70656 | 8832.0000 | 123 | 122368 | 994.8618 | 193024 | |
mysys/charset | 3 | 363300432 | 15054864 | 121099968 | 318247776 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 177 | 37997599200 | 0 | 214675560 | 22492515408 | 41 | 760 | 18.5366 | 3 | 156 | 52.0000 | 916 | |
sql/binlog_index | 38 | 46567840176 | 0 | 1225469256 | 30005200368 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2521929696 | 482592 | 315241080 | 1641109008 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 444587616 | 228624 | 88917312 | 423464448 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 14461920 | 612480 | 4820640 | 11151888 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 872329392 | 0 | 58155240 | 806985696 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 4124208 | 0 | 4124208 | 4124208 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 261254400 | 0 | 65313600 | 231190080 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|