From: Martin Thorpe (Martin.Thorpe@DATAFORCE.co.uk)
Date: Wed Mar 03 2004 - 10:56:17 EST
Hi guys
Hope everybody is well.
We have recently acquired a V880 (2x1.2ghz USparcIIIcu, 4GB ram, 6x73gb
10k rpm disks), this is going to house a large database running on a
PICK variant RDBMS (42GB - made up of smaller files - largest 3.5GB),
setup wise I have applied the following:
2 disks for root volume, RDBMS binaries and storage area - RAID 1
4 disks housing the database itself, these disks have been striped RAID
0 and then mirrored RAID 1 resulting in a RAID 10 configuration.
Filesystem wise, on the 4 disk setup I have applied the following:
(Average blocksize for a PICK file on this database is around 2-4k)
1. RAID 0 stripe size is 4912KB.
2. bsize=8192, fsize=8192, nbpci=8192, maxcontig=7, minfree=2%
3. mount options noatime.
System settings (/etc/system):
set shmsys:shminfo_shmmni=1024
set shmsys:shminfo_shmmax=8388608
set shmsys:shminfo_shmseg=50
set msgsys:msginfo_msgmni=1615
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=985
set semsys:seminfo_semmnu=1218
set maxpgio=240
set maxphys=1048576
This is giving reasonably good performance except asvc_t is sometimes
around a second. I am wondering if there is any further streamlining I
can do to increase performance further? This setup needs to be optimised
mainly for random WRITING and LOW average service times.
Changes that I thought of playing around with are ufs_LW and ufs_HW,
along with perhaps increasing shmmax to the maximum possible, although I
dont feel this is really going to give me anything.
Can I gain any benefit from using resource management, using FAIR SHARE
SCHEDULING? this box will server multipurpose, both in heavy processing
during the day (sporadically) and low level data entry in tandem, and we
cant afford high average service times which would effect data entry
screens freezing etc, perhaps this could help by building projects to
seperate the two roles.
If anybody can give me any tips or point me in the right direction, I
would appreciate it!
Many thanks
-- Martin Thorpe DATAFORCE GROUP LTD DDI: 01604 673886 MOBILE: 07740598932 WEB: http://www.dataforce.co.uk mailto: Martin.Thorpe@DATAFORCE.co.uk _______________________________________________ sunmanagers mailing list sunmanagers@sunmanagers.org http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:28:11 EDT