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 | 2635 | 2578053881040 | 0 | 978388488 | 245722290528 | 1291 | 26263552 | 20343.5724 | 986 | 40943616 | 41524.9655 | 67207168 | |
sql/io_cache | 112 | 4321088112 | 0 | 38580960 | 1631198976 | 40 | 2977528 | 74438.2000 | 52 | 2977528 | 57260.1538 | 5955056 | |
innodb/innodb_temp_file | 233 | 1184251137168 | 0 | 5082622776 | 639797490288 | 0 | 0 | 0.0000 | 166 | 3833856 | 23095.5181 | 3833856 | |
sql/ERRMSG | 55 | 35311624656 | 2801568 | 642029520 | 3771919008 | 33 | 3379452 | 102407.6364 | 0 | 0 | 0.0000 | 3379452 | |
innodb/innodb_log_file | 738 | 4240390874544 | 289872 | 5745787080 | 68441111376 | 8 | 70656 | 8832.0000 | 434 | 360448 | 830.5253 | 431104 | |
mysys/charset | 3 | 312624048 | 1823712 | 104207928 | 296586048 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 221 | 77302728624 | 0 | 349786008 | 24551762400 | 51 | 800 | 15.6863 | 5 | 632 | 126.4000 | 1432 | |
sql/binlog_index | 38 | 58707549120 | 0 | 1544935392 | 35885627184 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 650229888 | 154704 | 130045872 | 632027088 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 396801504 | 757680 | 99200376 | 345324144 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 50309952 | 2837472 | 16769808 | 39431040 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1118989344 | 0 | 74599272 | 1060058736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 212065392 | 0 | 70688376 | 188579424 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 7 | 677518512 | 0 | 96788208 | 444379056 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|