SAP on HP-UX:mount & filesystem options for best performance

回复 收藏
本帖最后由 spain.yx 于 2011-4-18 17:07 编辑

HP-UX:mount & filesystem options for best performance

此文档介绍HP-UX使用文件系统的IO(CIO、DIO)两种方式,主要针对于ORACLE数据库。


Setting the correct blocksizes
It is extremely important for Database performance that the filesystems use
the correct blocksize. This is equally true for direct I/O and buffered
I/O.
Using the wrong blocksize causes unnecessary I/O overhead since blocksize
used by the database processes does not match the filesystem blocksize.

o Oracle
For sapdata's use 8kb blockize
For redologs (origlog and mirrlog) use 1kb blocksize.

o Other filesystems (non-DB, executables etc.)
The default blocksize may be used.

o How to check filesystem blocksize on HP-UX:
fstyp -v  | grep f_frsize)
(e.g. fstyp -v /dev/vg00/lvol3 | grep f_frsize)

o How to create filesystems:
(For 8kb blocksize)
newfs -F vxfs -b 8192 -o largefiles /dev//r
(For 4kb blocksize)
newfs -F vxfs -b 4096 -o largefiles /dev//r
(For 1kb blocksize)


How to use Concurrent I/O:

o Check Concurrent I/O is available on the HP-UX system:
- Concurrent I/O (CIO) is available from VxFS 5.0 onwards.
- To enable CIO one of the following is required:
- VxFS 5.0 with an appropriate HP Storage Management Bundle,
e.g. "hp ServiceGuard Storage Management Suite"
- VxFS 5.0.1 (HP-UX 11.31 only) with an OnlineJFS License (For
more details see
http://h20341.www2.hp.com/enterprise/w1/en/os/hpux11i-fsvm-what
s-new.html )
The following command can be used to check VxFS 5.0.1 is
installed:
# /usr/sbin/swlist -l bundle | grep -iE 'vxfs|vxvm'
The following commands can be used to check OnlineJFS is
installed/enabled:
# vxlicrep | grep -i onlinejfs
or
# swlist -l product |grep -i onlinejfs

o Make sure the correct blocksizes are being used, see the section
"setting the correct blocksizes" above.

o For systems with >=40GB Memory set the buffercache/filecache to 1%
of Physical Memory (since the cache is not used by direct I/O).
e.g. dbc_max_pct=dbc_min_pct=1 (HP-UX 11.11/11.23) or
filecache_min=filecache_max=1 (HP-UX 11.31)

o For Oracle:
- Set the Oracle Parameter "FILESYSTEMIO_OPTIONS" to "SETALL".
See SAP Note 830576 (Oracle 10.2) and 1431798 (Oracle 11.2)
- Use the following mount options in /etc/fstab:
cio,delaylog,nodatainlog
e.g.
/dev/vg01/lvol1 /test vxfs cio,delaylog,nodatainlog 0 2
- Do this for sapdata's and redologs (origlog's and mirrlog's).
Other filesystems should keep their default options (i.e.
buffered I/O).
- Note: From Oracle Version 11.2.0.2 onwards the "cio" mount
option is no longer required for the database itself, but other
applications/utilities accessing these filesystems may still
require the mount option. Therefore it is still recommended to
use the "cio" mount option.


How to use direct I/O:

o Check Direct I/O is available on the HP-UX system:
- VxFS 5.0.1 (HP-UX 11.31 only) enables direct I/O by default.
The following command can be used to check VxFS 5.0.1 is
installed:
# /usr/sbin/swlist -l bundle | grep -iE 'vxfs|vxvm'
- Prior to VxFS 5.0.1 the "OnlineJFS" product is required to
enable direct I/O:
The following commands can be used to check OnlineJFS is
installed/enabled:
# vxlicrep | grep -i onlinejfs
or
# swlist -l product |grep -i onlinejfs

o Make sure the correct blocksizes are being used, see the section
"setting the correct blocksizes" above.

o For systems with >=40GB Memory set the buffercache/filecache to 1%
of Physical Memory (since the cache is not used by direct I/O).
e.g. dbc_max_pct=dbc_min_pct=1 (HP-UX 11.11/11.23) or
filecache_min=filecache_max=1 (HP-UX 11.31)

o For Oracle:
- Set the Oracle Parameter "FILESYSTEMIO_OPTIONS" to "SETALL".
See SAP Note 830576 (Oracle 10.2) and 1431798 (Oracle 11.2)
- Use the following mount options in /etc/fstab:
convosync=direct,mincache=direct,delaylog,nodatainlog
e.g.
/dev/vg01/lvol1 /test vxfs convosync=direct,mincache=direct,delaylog,nodatainlog 0 2
- Do this for sapdata's and redologs (origlog's and mirrlog's).
Other filesystems should keep their default options (i.e.
buffered I/O).
- Note: From Oracle Version 11.2.0.2 onwards the
"convosync=direct,mincache=direct" mount options are no longer
required for the database itself, but other
applications/utilities accessing these filesystems may still
require the mount options. Therefore it is still recommended to
use the "convosync=direct,mincache=direct" mount options.

其他数据库请参考:
SAP Note 1077887 - SAP on HP-UX:mount & filesystem options for best performance
2011-04-01 18:02 举报
已邀请:
0

alisaf8m86

赞同来自:

ng to an esthetics school means that you are looking for a career in cosmetology or you want to put up your own skin care business. Whatever the case may be, if you want to become a good esthetician, you will need to first get the education required to become one. This means you will need to find the best esthetics school to enroll in and to get your diploma from. To help you determine whether or not the esthetics schools you are looking to get into are the best ones for you, here are some things you might want to know about these schools:
1.        The best esthetics schools you can find will offer you both lectures and hands-on training to complete the course. This includes online schools that require you to attend hands-on lessons at institutions that they are affiliated with.
2.        Esthetics schools basically teach you Moncler Jackets Womens the specialized techniques and skills needed in the field of facial care. This includes deep pore cleansing, facial skin analysis, facial mask applications and even facial massage.
3.        Depending on what esthetics school you choose, you can get an Associate’s degree or a course certificate for your completed course. These courses Moncler Outlet For Sale 2013 often run for a minimum of 12 months to a maximum of 2 years for Associate’s degrees.
4.        Also included in the training modules of some of the best esthetics schools in the country are lessons on customer relations and communication skills, handling of different skin types and even business management for those who want to open their own skin care business in the future.
5.        Esthetician training programs vary from one to the other with some having more course modules than others. Some of the lessons you may or may not get from these training courses include exfoliation techniques, chemical peels and techniques, makeup artistry, body wraps, use of facial equipment, www.moncler-outlet-2013s.com waxing and hair removal and salon business management.
6.        Depending on which school you choose to go to, you may be required to present a high school diploma before you are allowed to Moncler Outlet Online enroll.
7.        Some esthetician schools require their students to practice not only their esthetician skills but also their communication skills since this is an important part of the job that Moncler Jackets Mens the person will be getting into upon finishing the course.
8.        You should be careful about online schools and check on their accreditation before you enroll. This is due to the fact that some cosmetology boards of certain states do not acknowledge the training a person gets from online institutions Moncler Outlet 2013 unless these are accredited by them beforehand.
9.        If you are thinking of practicing your craft in a certain state, it would be best to get your lessons from a school found in that state. Each state has individual licensing practices in place therefore it would be best to get your education from a school that is found in the state you will be working in as an esthetician.
10.        To help you see exactly what an esthetician school has to offer, do not simply rely on its website. Instead, pay the school a visit and see what facilities they have for their students and interact with some of the students there to get a feel of the school itself.
相关的主题文章:

  
   How To Choose The Right TExES Practice Guide
  
   Teach Yourself French Online Today, It's Easy
  
   Geothermal Power 101

回复帖子,请先登录注册

退出全屏模式 全屏模式 回复
评分
可选评分理由: