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 | 3266 | 3466324623696 | 0 | 1061336232 | 359151639792 | 1571 | 30851072 | 19637.8561 | 1196 | 47235072 | 39494.2074 | 78086144 | |
sql/ERRMSG | 75 | 32727483888 | 2518032 | 436366392 | 3008829120 | 45 | 4600135 | 102225.2222 | 0 | 0 | 0.0000 | 4600135 | |
innodb/innodb_temp_file | 126 | 571196737056 | 0 | 4533307416 | 31752277920 | 0 | 0 | 0.0000 | 55 | 2277376 | 41406.8364 | 2277376 | |
innodb/innodb_log_file | 1003 | 5225513902752 | 225456 | 5209884240 | 33784459632 | 8 | 70656 | 8832.0000 | 582 | 464384 | 797.9107 | 535040 | |
mysys/charset | 3 | 275962368 | 1840608 | 91987368 | 262316208 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 703 | 190626639456 | 0 | 271161528 | 32135914800 | 170 | 1570 | 9.2353 | 11 | 5503 | 500.2727 | 7073 | |
sql/SDI | 7 | 538636560 | 0 | 76948080 | 448634736 | 0 | 0 | 0.0000 | 2 | 6755 | 3377.5000 | 6755 | |
myisam/dfile | 151 | 1593353520 | 0 | 10551816 | 913969584 | 88 | 3806 | 43.2500 | 1 | 24 | 24.0000 | 3830 | |
myisam/kfile | 49 | 1676492400 | 0 | 34213872 | 440617056 | 12 | 2452 | 204.3333 | 17 | 844 | 49.6471 | 3296 | |
sql/binlog_index | 38 | 48177874800 | 0 | 1267838616 | 26657614368 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 721709472 | 638880 | 90213552 | 307206768 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 694143648 | 208032 | 138828624 | 679795248 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 44671440 | 2683824 | 14890392 | 34381248 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 733951152 | 0 | 48930024 | 657615024 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 41454336 | 0 | 13818024 | 16729680 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 6 | 488585328 | 0 | 81430800 | 402554064 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|