Mount option for database

[gigiz]

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

[Ganesan R]

Hi,

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

[Steven E. Protter]

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

[Ganesan R]

Hi,

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

[gigiz]

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

[Shahul]

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]

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.

[gigiz]

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]

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

man 1m mount_vxfs

[gigiz]

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