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 | 3346 | 5712657428016 | 0 | 1707309384 | 386056087824 | 1532 | 30212096 | 19720.6893 | 1189 | 46284800 | 38927.5021 | 76496896 | |
sql/io_cache | 138 | 3601691808 | 0 | 26099040 | 635527200 | 64 | 3238472 | 50601.1250 | 54 | 3238472 | 59971.7037 | 6476944 | |
sql/ERRMSG | 70 | 49784398224 | 2917728 | 711205440 | 3459943344 | 42 | 4301745 | 102422.5000 | 0 | 0 | 0.0000 | 4301745 | |
innodb/innodb_temp_file | 202 | 642929992320 | 0 | 3182821488 | 35153196672 | 0 | 0 | 0.0000 | 134 | 3375104 | 25187.3433 | 3375104 | |
innodb/innodb_log_file | 991 | 6049378749744 | 230736 | 6104317560 | 107043385152 | 8 | 70656 | 8832.0000 | 572 | 504832 | 882.5734 | 575488 | |
mysys/charset | 3 | 258320832 | 1472064 | 86106768 | 244877952 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/dfile | 111 | 2060204784 | 177936 | 18560256 | 1733827392 | 100 | 6700 | 67.0000 | 0 | 0 | 0.0000 | 6700 | |
sql/binlog | 561 | 256187119056 | 0 | 456661392 | 29119320384 | 130 | 1116 | 8.5846 | 17 | 4263 | 250.7647 | 5379 | |
myisam/kfile | 8 | 855288720 | 586608 | 106911024 | 545399184 | 4 | 799 | 199.7500 | 0 | 0 | 0.0000 | 799 | |
sql/binlog_index | 38 | 67456472688 | 0 | 1775170320 | 33164253408 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 816217776 | 208560 | 163243344 | 800886240 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 58247376 | 3144240 | 19415616 | 34265616 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1166243760 | 0 | 77749584 | 1102134000 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 281735520 | 0 | 93911664 | 254605824 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|