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 | 2912 | 3915157766256 | 0 | 1344490752 | 231370006560 | 1541 | 30359552 | 19701.2018 | 883 | 36978688 | 41878.4689 | 67338240 | |
sql/ERRMSG | 55 | 29395974432 | 3097776 | 534472224 | 4106276592 | 33 | 3382489 | 102499.6667 | 0 | 0 | 0.0000 | 3382489 | |
innodb/innodb_temp_file | 114 | 601448938464 | 0 | 5275867872 | 55495877712 | 0 | 0 | 0.0000 | 46 | 1933312 | 42028.5217 | 1933312 | |
sql/io_cache | 24 | 25196620416 | 0 | 1049859096 | 19493443728 | 8 | 595918 | 74489.7500 | 11 | 595918 | 54174.3636 | 1191836 | |
innodb/innodb_log_file | 798 | 4849980961056 | 234432 | 6077670192 | 65793332880 | 8 | 70656 | 8832.0000 | 452 | 347648 | 769.1327 | 418304 | |
mysys/charset | 3 | 304999200 | 2276736 | 101666400 | 292130784 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/dfile | 114 | 1164957552 | 101904 | 10218912 | 691412304 | 75 | 3948 | 52.6400 | 0 | 0 | 0.0000 | 3948 | |
sql/binlog | 1257 | 41298540624 | 0 | 32854800 | 17564317584 | 311 | 1840 | 5.9164 | 3 | 156 | 52.0000 | 1996 | |
myisam/kfile | 16 | 7158706368 | 623040 | 447419016 | 3595345248 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
sql/binlog_index | 38 | 52235987760 | 0 | 1374631104 | 32537529552 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1446603840 | 792528 | 180825480 | 821921232 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 1060181760 | 413952 | 212036352 | 1028748864 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 49834224 | 2896608 | 16611408 | 30679440 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 933874656 | 0 | 62258064 | 864674448 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 13716912 | 0 | 13716912 | 13716912 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 11 | 315137328 | 0 | 28648752 | 228041616 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|