Solved

CIO on best XFS options for Oracle with redhat

Posted on 2014-01-16
3
1,088 Views
Last Modified: 2014-01-22
we have seen too many issues with ext4 and redhat 6.5.after switching to XFS the database is performing at its best..
Now we need to make sure that we are getting the best out of XFS for redhat
how can we do that?

Also how can we determine if we have CIO running with our redhat 6.5 oracle 11g and XFS file system?

mount options

/dev/mapper/oracle_scripts_vg-oracle_scripts_lv on /u002 type xfs (rw,noatime,nobarrier,inode64,logbsize=256k)
/dev/mapper/oracle_data_vg-oracle_data_lv on /u003 type xfs (rw,noatime,nobarrier,inode64,logbsize=256k)
/dev/mapper/oracle_arch_redo_vg-oracle_arch_redo_lv on /u004 type xfs (rw,noatime,nobarrier,inode64,logbsize=256kg)
/dev/mapper/oracle_redo1_vg-oracle_redo1_lv on /u005 type xfs (rw,noatime,nobarrier,inode64,logbsize=256kg)
/dev/mapper/oracle_rman1_vg-oracle_rman1_lv on /u010 type xfs (rw,noatime,nobarrier,inode64,logbsize=256kg)
/dev/mapper/oracle_redo2_vg-oracle_redo2_lv on /u015 type xfs (rw,noatime,nobarrier,inode64,logbsize=256kg)
0
Comment
Question by:it-rex
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 62

Expert Comment

by:gheist
ID: 39788974
You need to try all FILESYSTEMIO_OPTIONS

    ASYNCH -> aio api that leaves write request and gets signal when that is done, makes good use of NCQ
    DIRECTIO -> skips journal
    SETALL -> both
    NONE -> neither

Also noatime/relatim mount options help a lot, as you already have set it up
0
 
LVL 11

Author Comment

by:it-rex
ID: 39789115
I have  noatime.
  what is relatim?
0
 
LVL 62

Accepted Solution

by:
gheist earned 500 total points
ID: 39789208
relatime is haldfof noatime, that makes mail and news work (not needed for oracle, you have the best option selected)

Also you might want to try Oracle Enterprise Linux UEK kernel, it has much newer kernel and xfs code.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have been running these systems for a few years now and I am just very happy with them.   I just wanted to share the manual that I have created for upgrades and other things.  Oooh yes! FreeBSD makes me happy (as a server), no maintenance and I al…
Java performance on Solaris - Managing CPUs There are various resource controls in operating system which directly/indirectly influence the performance of application. one of the most important resource controls is "CPU".   In a multithreaded…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question