cancel
Showing results for 
Search instead for 
Did you mean: 

Mount option for database

gigiz
Valued Contributor

Mount option for database

Hi,
i have 2 nodes of cluster with :

Server1:
/oraexport on /dev/vg_product/oraexport log on Mon Feb 2 21:59:05 2009
/oradata on /dev/vg_db1/lvol_oradata log on Mon Feb 2 21:59:12 2009
/oradata3 on /dev/vg_db3/lvoloradata3 log on Mon Feb 2 21:59:12 2009
/oradata4 on /dev/vg_db4/lvoloradata4 log on Mon Feb 2 21:59:12 2009
/oradata5 on /dev/vg_db5/lvoloradata5 log on Mon Feb 2 21:59:12 2009
/oraindx on /dev/vg_indx/lvol_oraindx log on Mon Feb 2 21:59:13 2009
/oradata2 on /dev/vg_dati/lvol_oradata log on Mon Feb 2 21:59:13 2009

Server 2:

/product/ora10gbis on /dev/vg_oracle/lvol_oracle log,nodatainlog,largefiles on Fri Feb 20 18:01:42 2009
/product/ora10g on /dev/vg_product/lvol_ora10g log,nodatainlog,largefiles on Fri Feb 20 18:01:42 2009
/oraindx on /dev/vg_indx/lvol_oraindx log,nodatainlog,largefiles on Fri Feb 20 18:01:42 2009
/oraexport on /dev/vg_product/lvol_oraexport log,nodatainlog,largefiles on Fri Feb 20 18:01:42 2009
/oradata5 on /dev/vg_db5/lvoloradata5 log,nodatainlog,largefiles on Fri Feb 20 18:01:42 2009
/oradata4 on /dev/vg_db4/lvoloradata4 log,nodatainlog,largefiles on Fri Feb 20 18:01:42 2009
/oradata3 on /dev/vg_db3/lvoloradata3 log,nodatainlog,largefiles on Fri Feb 20 18:01:42 2009
/oradata2 on /dev/vg_dati/lvol_oradata2 log,nodatainlog,largefiles on Fri Feb 20 18:01:42 2009
/oradata on /dev/vg_db1/lvol_oradata log,nodatainlog,largefiles on Fri Feb 20 18:01:43 2009

by a statistic i see that a server2 have better read performance of the server1.
Server1 is very slow to read between 7 and 11
server2 is more fast to read between 05 and 4

I want knwo if it can depend by the "MOUNT OPTION".
Many point at all
10 REPLIES
Ganesan R
Honored Contributor

Re: Mount option for database

Hi,

It is apparently with mount options. Use the same mount options used on server2 with server1 also.

Best wishes,

Ganesh.
Steven E. Protter
Exalted Contributor

Re: Mount option for database

Shalom,

The database could require defragmentation (oracle).

The underlying storage could be configured differently.

The load could be different on the server.

http://www.hpux.ws/?p=6
That script set might help you gather data.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Ganesan R
Honored Contributor

Re: Mount option for database

Hi,

man 1m mount_vxfs -->Will show what options and how the options affect the performance.
Best wishes,

Ganesh.
gigiz
Valued Contributor

Re: Mount option for database

yes but i want know if at same condition this option can slow or fast the performance .
HELP
Shahul
Esteemed Contributor

Re: Mount option for database

Yes, Mount option definetely matters especially for Oracle filesystems. I would prefer the following options, it is very similar to your 2nd server.

vxfs delaylog,mincache=direct,convosync=direct 0 2

Good luck
Shahul
Ganesan R
Honored Contributor

Re: Mount option for database

Hi,

There are good documents available regarding filesystem tuning. One among is http://docs.hp.com/en/5576/JFS_Tuning.pdf

But the best way is, get the recommandations from dba/application vendor. They should know which option will give better performance for their dba/applications.
Best wishes,

Ganesh.
gigiz
Valued Contributor

Re: Mount option for database

But for server1 and server2 the different is largefiles that permit file more large of 2 Gb and nodatainlog that ??
is it nodatainlog that improve the performance of server2?
Ganesan R
Honored Contributor

Re: Mount option for database

>>>is it nodatainlog that improve the performance of server2?<<<

man 1m mount_vxfs
Best wishes,

Ganesh.
gigiz
Valued Contributor

Re: Mount option for database

But in the man there are 2 options:

datainlog|nodatainlog
Generally, VxFS does O_SYNC or O_DSYNC writes by logging
the data and the time change to the inode (datainlog).
If the nodatainlog option is used, the logging of
synchronous writes is disabled; O_SYNC writes the data
into the file and updates the inode synchronously before
returning to the user.

If i don't specify in my mount option, datainlog and nodatainlog what happen?

If i would set nodatainlog on my file system before i must umount a file system ?

other many point

Ganesan R
Honored Contributor

Re: Mount option for database

Hi again,

>>If i don't specify in my mount option, datainlog and nodatainlog what happen?<<<

You should have online JFS to enable this mount options.

>>>If i would set nodatainlog on my file system before i must umount a file system?<<<

Though I haven't tried, you can try with fsadm to change it online. If it doesn't work you need to remount it.

This thread will give you some more informations..

http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=968618

Also check this..

http://h20195.www2.hp.com/v2/GetPDF.aspx/4AA1-9839ENW.pdf

Best wishes,

Ganesh.