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 | 2176 | 2047799820528 | 0 | 941084232 | 281476249824 | 1287 | 26198016 | 20355.8788 | 593 | 28688384 | 48378.3879 | 54886400 | |
innodb/innodb_temp_file | 159 | 1026016553760 | 0 | 6452934048 | 39085644576 | 0 | 0 | 0.0000 | 77 | 3358720 | 43619.7403 | 3358720 | |
sql/ERRMSG | 50 | 39097862496 | 2755632 | 781957176 | 9278350752 | 30 | 3069156 | 102305.2000 | 0 | 0 | 0.0000 | 3069156 | |
innodb/innodb_log_file | 437 | 2538644922528 | 227568 | 5809256112 | 63198434112 | 8 | 70656 | 8832.0000 | 253 | 217600 | 860.0791 | 288256 | |
mysys/charset | 3 | 341592240 | 2270400 | 113863992 | 319848144 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 191 | 65206311456 | 0 | 341394240 | 26435003760 | 44 | 772 | 17.5455 | 4 | 394 | 98.5000 | 1166 | |
sql/binlog_index | 38 | 82209040320 | 0 | 2163395784 | 53063484144 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 14342219232 | 244464 | 2868443688 | 14322375936 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 661642608 | 663696 | 165410520 | 601390416 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 24521904 | 780912 | 8173968 | 17727600 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 967200432 | 0 | 64479888 | 881860320 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 188742048 | 0 | 94371024 | 183763008 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 190163424 | 0 | 95081712 | 179878512 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|