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 | 3051 | 2915777336208 | 0 | 955679208 | 226178441808 | 1362 | 27426816 | 20137.1630 | 1132 | 45662208 | 40337.6396 | 73089024 | |
sql/ERRMSG | 95 | 67819149024 | 2794176 | 713885568 | 7613953776 | 57 | 5827436 | 102235.7193 | 0 | 0 | 0.0000 | 5827436 | |
innodb/innodb_log_file | 1723 | 7245706978224 | 237600 | 4205285304 | 120036254448 | 8 | 70656 | 8832.0000 | 1187 | 2255360 | 1900.0505 | 2326016 | |
innodb/innodb_temp_file | 95 | 416505341472 | 0 | 4384266744 | 39078256800 | 0 | 0 | 0.0000 | 33 | 1327104 | 40215.2727 | 1327104 | |
mysys/charset | 3 | 283947312 | 3148464 | 94649016 | 264195360 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 603 | 554979450960 | 0 | 920363928 | 42039852624 | 129 | 1112 | 8.6202 | 40 | 8137 | 203.4250 | 9249 | |
sql/binlog_index | 38 | 58696670736 | 0 | 1544649216 | 34755832848 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1731926064 | 1765632 | 216490560 | 536996064 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1047310176 | 210672 | 209461824 | 1020015744 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 14674704 | 759264 | 4891392 | 11782320 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1236568608 | 0 | 82437696 | 1160981184 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 7 | 115897584 | 0 | 16556760 | 25145472 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 95826192 | 0 | 23956416 | 34335312 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 590882160 | 0 | 147720408 | 511215936 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/kfile | 4 | 455859360 | 0 | 113964840 | 228046368 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|