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 | 2517 | 2858175321936 | 0 | 1135548216 | 204107782560 | 1502 | 29720576 | 19787.3342 | 621 | 28983296 | 46671.9742 | 58703872 | |
innodb/innodb_temp_file | 592 | 1043558666304 | 0 | 1762767864 | 33646830096 | 0 | 0 | 0.0000 | 504 | 10747904 | 21325.2063 | 10747904 | |
sql/io_cache | 154 | 16421171184 | 0 | 106630920 | 12979834560 | 54 | 3971412 | 73544.6667 | 70 | 3971412 | 56734.4571 | 7942824 | |
sql/ERRMSG | 55 | 27224894400 | 2483184 | 494997888 | 2411078736 | 33 | 3382422 | 102497.6364 | 0 | 0 | 0.0000 | 3382422 | |
innodb/innodb_log_file | 487 | 2914332712896 | 232320 | 5984255904 | 283309614192 | 8 | 70656 | 8832.0000 | 272 | 227840 | 837.6471 | 298496 | |
mysys/charset | 3 | 278992032 | 1943568 | 92997168 | 267183312 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 389 | 91170106896 | 0 | 234370224 | 24051409536 | 93 | 968 | 10.4086 | 5 | 717 | 143.4000 | 1685 | |
myisam/kfile | 4 | 283186992 | 764016 | 70796616 | 249570288 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 79966011312 | 0 | 2104368552 | 42666337824 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 628430352 | 175824 | 125685912 | 607543200 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 20008032 | 806256 | 6669168 | 11877888 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1222589808 | 0 | 81505776 | 1157854368 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 215864352 | 0 | 71954784 | 199829520 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 8373552 | 420288 | 4186776 | 7953264 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|