Oracle Linux 6 使用 Ext4的性能体验
SQL> create tablespace eygle datafile '/data1/oradata/mobiledb/MOBILEDB/eygle01.dbf' size 10240M;
Tablespace created.
Elapsed: 00:00:25.94操作系统IOSTAT输出:
[oracle@Oracle112 ~]$ iostat -m 2
Linux 2.6.32-71.el6.x86_64 (Oracle112) 02/19/2011 _x86_64_ (16 CPU)
avg-cpu: %user %nice %system %iowait %steal %idle
0.06 0.00 0.22 0.00 0.00 99.72
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 8.00 0.00 0.04 0 0
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.36 0.00 2.22 0.03 0.00 97.39
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 231.50 0.00 64.13 0 128
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.65 0.00 6.37 5.39 0.00 87.59
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 1150.00 0.00 565.60 0 1131
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.37 0.00 4.60 11.47 0.00 83.57
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 909.00 0.00 447.31 0 894
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.21 0.00 4.66 15.11 0.00 80.02
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 893.50 0.00 440.72 0 881
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.29 0.00 3.31 12.93 0.00 83.47
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 879.50 0.00 436.29 0 872
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.36 0.00 3.43 17.98 0.00 78.23
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 670.00 0.31 320.53 0 641
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
1.19 0.00 5.99 17.97 0.00 74.86
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 978.50 1.27 467.29 2 934
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.63 0.00 6.39 20.20 0.00 72.79
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 895.00 0.00 442.00 0 884
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.38 0.00 4.51 14.20 0.00 80.91
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 899.50 0.00 445.09 0 890
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.36 0.00 4.33 13.77 0.00 81.54
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 891.00 0.00 442.24 0 884
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.26 0.00 4.76 14.52 0.00 80.45
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 897.50 0.00 445.04 0 890
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.39 0.00 2.81 8.23 0.00 88.56
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 579.50 0.37 256.86 0 513
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.07 0.00 6.82 0.03 0.00 93.08
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 256.00 0.00 92.04 0 184
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.03 0.00 6.44 0.09 0.00 93.44
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 429.00 0.00 152.04 0 304
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.14 0.00 2.01 0.85 0.00 97.00
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 733.50 0.07 105.30 0 210
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.07 0.00 0.10 0.00 0.00 99.83
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 8.00 0.00 0.04 0 0
scd0 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
0.14 0.00 0.31 0.14 0.00 99.41
Device: tps MB_read/s MB_wrtn/s MB_read MB_wrtn
sda 19.50 0.36 0.04 0 0
scd0 0.00 0.00 0.00 0 0初步感觉是不错的,有待于进一步测试。
By eygle on 2011-02-21 09:34 |
Comments (4) |
OraNews | 2743 |
4 Comments
大块或者流媒体存储在这种文件系统较以前肯定性能提升很大,对于大量分散读写的oltp类型可能还需要做典型的场景测试,我觉得性能肯定是提升的,具体能到什么程度,这个不好说
其实主机性能测试也是以个很重要的步骤,特别是采购了新型号的机器后
oltp应用的iops/tps的测试,还有条带大小、db(block size)、io调度器的都可以调优测试