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 | 2505 | 2331942940272 | 0 | 930915216 | 242657951712 | 1474 | 29261824 | 19851.9837 | 656 | 30425088 | 46379.7073 | 59686912 | |
sql/ERRMSG | 90 | 67670267280 | 2505888 | 751891800 | 10130016864 | 54 | 5521548 | 102250.8889 | 0 | 0 | 0.0000 | 5521548 | |
innodb/innodb_temp_file | 110 | 523024508688 | 0 | 4754768040 | 27586342608 | 0 | 0 | 0.0000 | 43 | 1818624 | 42293.5814 | 1818624 | |
innodb/innodb_log_file | 537 | 2712526085280 | 226512 | 5051258784 | 36046218912 | 8 | 70656 | 8832.0000 | 309 | 278016 | 899.7282 | 348672 | |
mysys/charset | 3 | 317317440 | 2426688 | 105772392 | 303231984 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 332 | 83129663232 | 0 | 250390536 | 26314976688 | 79 | 1059 | 13.4051 | 6 | 1110 | 185.0000 | 2169 | |
myisam/kfile | 8 | 1399347840 | 680064 | 174918480 | 730844928 | 4 | 904 | 226.0000 | 0 | 0 | 0.0000 | 904 | |
sql/binlog_index | 38 | 40859835984 | 0 | 1075258800 | 23814088320 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2320303920 | 605616 | 290037792 | 1470409776 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 974238672 | 256608 | 194847576 | 954760752 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 15324672 | 753984 | 5108136 | 10563168 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 882770592 | 0 | 58851144 | 821863152 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 212163072 | 0 | 70720848 | 198948288 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 8 | 71031840 | 0 | 8878848 | 22078320 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 22809600 | 653664 | 5702400 | 8223600 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|