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 | 3205 | 2921961630720 | 0 | 911688360 | 193450429920 | 1481 | 31293440 | 21129.9392 | 1124 | 45236224 | 40245.7509 | 76529664 | |
sql/io_cache | 1555 | 207326731920 | 0 | 133328976 | 46995723456 | 658 | 37992456 | 57739.2948 | 657 | 37974960 | 57800.5479 | 75967416 | |
innodb/innodb_temp_file | 1423 | 1216733319648 | 0 | 855047952 | 26838795456 | 0 | 0 | 0.0000 | 1314 | 25395200 | 19326.6362 | 25395200 | |
sql/ERRMSG | 70 | 54783123120 | 2540736 | 782615856 | 7199022336 | 42 | 4303485 | 102463.9286 | 0 | 0 | 0.0000 | 4303485 | |
innodb/innodb_log_file | 928 | 4867398198960 | 234432 | 5245041120 | 46663834272 | 8 | 70656 | 8832.0000 | 548 | 531968 | 970.7445 | 602624 | |
sql/binlog | 579 | 182761028736 | 0 | 315649224 | 19029684432 | 146 | 102577 | 702.5822 | 12 | 2872 | 239.3333 | 105449 | |
mysys/charset | 3 | 560751840 | 8120640 | 186917280 | 515862864 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog_index | 23 | 1296421632 | 0 | 56366112 | 410577552 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | 160 | |
csv/metadata | 8 | 11133834096 | 1013760 | 1391729064 | 10659491568 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 196940832 | 380688 | 39388008 | 177573792 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 16449312 | 826848 | 5483016 | 13439712 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 | 5 | |
sql/casetest | 15 | 967697808 | 0 | 64513152 | 864347616 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 61646112 | 0 | 15411528 | 32356896 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 15 | 866611680 | 0 | 57774024 | 400167504 | 5 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|