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 | 1700 | 994753906608 | 0 | 585149136 | 240121185216 | 1221 | 25116672 | 20570.5749 | 291 | 19349504 | 66493.1409 | 44466176 | |
sql/ERRMSG | 35 | 18274096896 | 3324816 | 522117024 | 2704518432 | 21 | 2140921 | 101948.6190 | 0 | 0 | 0.0000 | 2140921 | |
innodb/innodb_temp_file | 90 | 374046563616 | 0 | 4156072800 | 43392095472 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | 1146880 | |
innodb/innodb_log_file | 247 | 1638484416096 | 237072 | 6633540144 | 150526566432 | 8 | 70656 | 8832.0000 | 142 | 133632 | 941.0704 | 204288 | |
mysys/charset | 3 | 320595792 | 2679072 | 106865088 | 290282256 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 77 | 58688829408 | 0 | 762192552 | 35630787456 | 16 | 660 | 41.2500 | 3 | 156 | 52.0000 | 816 | |
sql/binlog_index | 38 | 64437920976 | 0 | 1695734568 | 41045487648 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 2991714528 | 302544 | 598342800 | 2963843520 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 594369072 | 642048 | 148592136 | 524882160 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 19576656 | 974688 | 6525552 | 15720672 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 766587360 | 0 | 51105648 | 689872128 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 3546576 | 0 | 3546576 | 3546576 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 15312000 | 0 | 7656000 | 9331872 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|