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 | 3145 | 3006588075744 | 0 | 955989672 | 230358733440 | 1340 | 27066368 | 20198.7821 | 1422 | 54870016 | 38586.5091 | 81936384 | |
sql/io_cache | 530 | 149676306912 | 0 | 282407928 | 127129271280 | 224 | 12524914 | 55914.7946 | 216 | 12524914 | 57985.7130 | 25049828 | |
innodb/innodb_temp_file | 919 | 1138751572464 | 0 | 1239120168 | 58998639216 | 0 | 0 | 0.0000 | 822 | 16547840 | 20131.1922 | 16547840 | |
sql/ERRMSG | 25 | 17925923664 | 3315312 | 717036936 | 3462545328 | 15 | 1535694 | 102379.6000 | 0 | 0 | 0.0000 | 1535694 | |
innodb/innodb_log_file | 1170 | 5933343784896 | 229152 | 5071233816 | 37966513200 | 8 | 70656 | 8832.0000 | 690 | 540672 | 783.5826 | 611328 | |
mysys/charset | 3 | 247294080 | 3451536 | 82431360 | 227166192 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 121 | 64018815696 | 0 | 529081080 | 17455792464 | 26 | 700 | 26.9231 | 5 | 591 | 118.2000 | 1291 | |
sql/binlog_index | 38 | 53821200048 | 0 | 1416347328 | 35815364640 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 859982640 | 210144 | 171996528 | 831023952 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 8988567456 | 1765104 | 2247141864 | 8554132224 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 22796928 | 1093488 | 7598976 | 18620976 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 890187408 | 0 | 59345616 | 788670960 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 3 | 42854592 | 0 | 14284776 | 17484192 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 884000832 | 0 | 442000416 | 847356576 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|