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 | 3779 | 6667555698672 | 0 | 1764370344 | 278395523472 | 1514 | 29917184 | 19760.3593 | 1512 | 57786368 | 38218.4974 | 87703552 | |
sql/ERRMSG | 60 | 54947626272 | 2704416 | 915793560 | 4634495184 | 36 | 3685427 | 102372.9722 | 0 | 0 | 0.0000 | 3685427 | |
innodb/innodb_temp_file | 127 | 559404881376 | 0 | 4404762648 | 32408197536 | 0 | 0 | 0.0000 | 58 | 2195456 | 37852.6897 | 2195456 | |
innodb/innodb_log_file | 1938 | 10209166200816 | 232848 | 5267887416 | 50796712032 | 8 | 70656 | 8832.0000 | 1227 | 1721344 | 1402.8883 | 1792000 | |
mysys/charset | 3 | 321378288 | 1868064 | 107125920 | 295412832 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 409 | 502158989904 | 0 | 1227772392 | 41269835904 | 85 | 936 | 11.0118 | 31 | 10416 | 336.0000 | 11352 | |
myisam/kfile | 4 | 523228992 | 1110384 | 130807248 | 497118336 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 54780724416 | 0 | 1441597872 | 35846631216 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1584070752 | 850608 | 198008712 | 643265040 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 816378816 | 178992 | 163275552 | 799818624 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 49150992 | 2757216 | 16383576 | 38415696 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1295534592 | 0 | 86368920 | 1232812416 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 6 | 152739840 | 0 | 25456464 | 72163872 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 9 | 2237522496 | 0 | 248613552 | 1875438576 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 10882608 | 609312 | 5441304 | 10273296 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|