topic Re: Mount option for database in Operating System - HP-UX

Mount option for database

gigiz — Wed, 04 Mar 2009 13:33:18 GMT

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

Re: Mount option for database

Ganesan R — Wed, 04 Mar 2009 13:49:27 GMT

Hi,

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

Re: Mount option for database

Steven E. Protter — Wed, 04 Mar 2009 14:02:52 GMT

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

Re: Mount option for database

Ganesan R — Wed, 04 Mar 2009 14:12:23 GMT

Hi,

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

Re: Mount option for database

gigiz — Wed, 04 Mar 2009 14:30:06 GMT

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

Re: Mount option for database

Shahul — Wed, 04 Mar 2009 15:00:47 GMT

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

Re: Mount option for database

Ganesan R — Wed, 04 Mar 2009 15:11:40 GMT

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.

Re: Mount option for database

gigiz — Wed, 04 Mar 2009 15:11:43 GMT

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?

Re: Mount option for database

Ganesan R — Wed, 04 Mar 2009 16:03:15 GMT

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

man 1m mount_vxfs

Re: Mount option for database

gigiz — Thu, 05 Mar 2009 14:06:30 GMT

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

Re: Mount option for database

Ganesan R — Thu, 05 Mar 2009 14:44:20 GMT

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