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 | 2816 | 2522684553840 | 0 | 895839648 | 218324580144 | 1459 | 29016064 | 19887.6381 | 989 | 41107456 | 41564.6673 | 70123520 | |
sql/ERRMSG | 65 | 60696232080 | 2576640 | 933788064 | 14732877456 | 39 | 3990815 | 102328.5897 | 0 | 0 | 0.0000 | 3990815 | |
innodb/innodb_temp_file | 159 | 817942232448 | 0 | 5144290536 | 50053304928 | 0 | 0 | 0.0000 | 78 | 3309568 | 42430.3590 | 3309568 | |
innodb/innodb_log_file | 939 | 5379252672816 | 314688 | 5728703376 | 358540441248 | 8 | 70656 | 8832.0000 | 551 | 436736 | 792.6243 | 507392 | |
mysys/charset | 3 | 211558512 | 1887600 | 70519416 | 195822528 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 602 | 141200523024 | 0 | 234552120 | 37606546032 | 145 | 1323 | 9.1241 | 9 | 1729 | 192.1111 | 3052 | |
myisam/kfile | 16 | 2877366096 | 491040 | 179835216 | 986960832 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
myisam/dfile | 16 | 1124340096 | 305184 | 70271256 | 751138608 | 2 | 522 | 261.0000 | 0 | 0 | 0.0000 | 522 | |
sql/binlog_index | 38 | 49099389504 | 0 | 1292089128 | 27390861168 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 1099530960 | 904992 | 137441304 | 538285968 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 560425536 | 143088 | 112084896 | 529663200 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13878480 | 752400 | 4626072 | 9162912 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1006781952 | 0 | 67118568 | 945786864 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 40884624 | 0 | 13628208 | 14374272 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 295304592 | 0 | 73826016 | 260711088 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|