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 | 2115 | 1080841592688 | 0 | 511036152 | 212631757008 | 1282 | 26116096 | 20371.3697 | 629 | 30195712 | 48005.9014 | 56311808 | |
sql/ERRMSG | 50 | 23040172320 | 2818464 | 460803288 | 2228683776 | 30 | 3071469 | 102382.3000 | 0 | 0 | 0.0000 | 3071469 | |
innodb/innodb_temp_file | 90 | 306853256160 | 0 | 3409480536 | 19815427104 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | 1146880 | |
innodb/innodb_log_file | 414 | 2052494968128 | 242880 | 4957717248 | 73861471728 | 8 | 70656 | 8832.0000 | 245 | 223744 | 913.2408 | 294400 | |
mysys/charset | 3 | 256080528 | 2235552 | 85360176 | 241688304 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 289 | 33878172240 | 0 | 117225504 | 17067959568 | 69 | 872 | 12.6377 | 3 | 156 | 52.0000 | 1028 | |
sql/binlog_index | 38 | 55465122240 | 0 | 1459608480 | 33946737792 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 901218384 | 695904 | 112652232 | 462227040 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1721957424 | 183744 | 344391432 | 1704012288 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 12593856 | 707520 | 4197864 | 10365168 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 973536432 | 0 | 64902288 | 910188048 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 3222384 | 0 | 3222384 | 3222384 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 44618640 | 0 | 11154528 | 21905664 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|