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 | 3207 | 3346194742176 | 0 | 1043403240 | 192924036624 | 1400 | 28049408 | 20035.2914 | 1210 | 48185344 | 39822.5983 | 76234752 | |
sql/ERRMSG | 80 | 37546305984 | 2663232 | 469328640 | 3291350304 | 48 | 4911324 | 102319.2500 | 0 | 0 | 0.0000 | 4911324 | |
innodb/innodb_log_file | 1819 | 8643559862256 | 242352 | 4751819424 | 759259998816 | 8 | 70656 | 8832.0000 | 1256 | 2332672 | 1857.2229 | 2403328 | |
innodb/innodb_temp_file | 114 | 481378923696 | 0 | 4222621920 | 36581686416 | 0 | 0 | 0.0000 | 46 | 1933312 | 42028.5217 | 1933312 | |
mysys/charset | 3 | 311647776 | 2116752 | 103882416 | 284747760 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 471 | 601050660672 | 0 | 1276115808 | 35271999840 | 96 | 980 | 10.2083 | 40 | 7961 | 199.0250 | 8941 | |
sql/binlog_index | 38 | 52651441392 | 0 | 1385564136 | 35732659776 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2686535280 | 489984 | 335816712 | 1783789392 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 894842256 | 173184 | 178968240 | 871783968 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 16951968 | 635184 | 5650656 | 10218384 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 841494192 | 0 | 56099472 | 777238176 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 70983264 | 0 | 17745816 | 27013536 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 406029888 | 0 | 101507472 | 360158304 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 89029776 | 0 | 22257312 | 43913232 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/kfile | 4 | 912863424 | 0 | 228215856 | 725209584 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|