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 | 1547 | 737743245360 | 0 | 476886168 | 226643535360 | 1176 | 24379392 | 20730.7755 | 201 | 16433152 | 81756.9751 | 40812544 | |
sql/ERRMSG | 25 | 15845607888 | 3490080 | 633824136 | 4672718160 | 15 | 1531208 | 102080.5333 | 0 | 0 | 0.0000 | 1531208 | |
innodb/innodb_temp_file | 90 | 358023982800 | 0 | 3978044136 | 31411916448 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | 1146880 | |
innodb/innodb_log_file | 106 | 515547762576 | 227040 | 4863658008 | 22458681696 | 8 | 70656 | 8832.0000 | 55 | 71680 | 1303.2727 | 142336 | |
mysys/charset | 3 | 282142608 | 4266240 | 94047360 | 260812464 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 41 | 35591812080 | 0 | 868092720 | 16894247040 | 7 | 624 | 89.1429 | 3 | 156 | 52.0000 | 780 | |
sql/binlog_index | 38 | 60375651072 | 0 | 1588832784 | 38499614736 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1274529168 | 255552 | 254905728 | 1250302416 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 59673504 | 2690160 | 19891080 | 49547520 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 930362400 | 0 | 62024160 | 846147456 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 13252800 | 0 | 13252800 | 13252800 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|