From: Matt Lawrence (matt@TECHNORONIN.COM)
Date: Fri Jan 03 2003 - 18:39:14 EST
On Fri, 3 Jan 2003, Calderon, Linda wrote:
> Is it true that a typical database layout in an HP environment of many file
> systems would not perform well on an AIX system due to the overhead
> associated with too many file systems? I was advised in the AIX environment
> the number of mount points should be kept to a minimum. E.G.. A 60 GB
> database with about 25 file systems which performs well in HP platform,
> what should it be like in an AIX environment?
First, I highly recommend the Redbook on Performance Tuning DB2 and Oracle
Databases. There's a lot of good information for other databases also.
Having a DBA with a serious clue as to how to configure the tables &
indices on the appropriate spindles is almost a requirement when dealing
with a heavily used database (I've seen 10x speed improvements just by
rearranging to disk layouts.
Also, mirroring. You might want to make sure MWC is turned off for the
LVs that contain your tables and turned on for the LVs containing the
logs. It should be possible to resync the mirrors during the log replay
after a system crash.
If you have any other questions, please feel free to ask me.
-- Matt
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:26 EDT