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 | 1582 | 661853164368 | 0 | 418364760 | 239577561696 | 1250 | 25591808 | 20473.4464 | 167 | 15417344 | 92319.4251 | 41009152 | |
sql/io_cache | 56 | 1925662464 | 0 | 34386792 | 420390432 | 20 | 1497012 | 74850.6000 | 26 | 1497012 | 57577.3846 | 2994024 | |
sql/ERRMSG | 40 | 34620480576 | 3000624 | 865511856 | 8817364512 | 24 | 2457220 | 102384.1667 | 0 | 0 | 0.0000 | 2457220 | |
innodb/innodb_temp_file | 102 | 524198348784 | 0 | 5139199296 | 32415486576 | 0 | 0 | 0.0000 | 36 | 1638400 | 45511.1111 | 1638400 | |
innodb/innodb_log_file | 233 | 1266220740048 | 230736 | 5434423632 | 112432646304 | 8 | 70656 | 8832.0000 | 134 | 128512 | 959.0448 | 199168 | |
mysys/charset | 3 | 235881360 | 2349600 | 78627120 | 220082544 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 57 | 35983375824 | 0 | 631287096 | 17008751760 | 11 | 640 | 58.1818 | 3 | 156 | 52.0000 | 796 | |
sql/binlog_index | 38 | 56483247216 | 0 | 1486401048 | 34642195104 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1253021616 | 636768 | 156627504 | 595278816 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 842886000 | 402336 | 168577200 | 817944336 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 47182080 | 2574528 | 15727272 | 37812720 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 861802128 | 0 | 57453264 | 789346272 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 16325232 | 0 | 16325232 | 16325232 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 76322400 | 0 | 19080600 | 53467392 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|