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 | 2984 | 5264418632880 | 0 | 1764215112 | 738347057712 | 1441 | 28721152 | 19931.4032 | 1033 | 41730048 | 40396.9487 | 70451200 | |
sql/ERRMSG | 75 | 44290768368 | 2311056 | 590543448 | 4129903536 | 45 | 4600249 | 102227.7556 | 0 | 0 | 0.0000 | 4600249 | |
innodb/innodb_temp_file | 167 | 903055463904 | 0 | 5407517544 | 97859525280 | 0 | 0 | 0.0000 | 85 | 3489792 | 41056.3765 | 3489792 | |
innodb/innodb_log_file | 814 | 5111743600128 | 229680 | 6279783048 | 102480608208 | 8 | 70656 | 8832.0000 | 471 | 445952 | 946.8195 | 516608 | |
mysys/charset | 3 | 248289360 | 2090880 | 82762944 | 236422032 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/dfile | 37 | 2272282848 | 185328 | 61413000 | 1581275520 | 27 | 6648 | 246.2222 | 0 | 0 | 0.0000 | 6648 | |
sql/binlog | 671 | 164281619568 | 0 | 244830960 | 30334223040 | 161 | 1240 | 7.7019 | 10 | 2178 | 217.8000 | 3418 | |
myisam/kfile | 8 | 4470206928 | 659472 | 558775800 | 3898451568 | 4 | 904 | 226.0000 | 0 | 0 | 0.0000 | 904 | |
sql/binlog_index | 38 | 54798326880 | 0 | 1442061192 | 28263998400 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 421543584 | 158928 | 84308664 | 404722032 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 49488384 | 2988480 | 16496040 | 38462160 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 925461504 | 0 | 61697328 | 856153056 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 6 | 128183616 | 0 | 21363936 | 61776528 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|