From: Richard Mackerras (richard.mackerras@avonandsomerset.police.uk)
Date: Thu Jul 25 2002 - 09:13:47 EDT
Hi,
We have moved an Ingres 2 database from an E250 to a Blade 100 while we
implement it's Oracle based replacement on the E250. We are seeing a
reduction in performance from the Blade (not very surprising really). The
Ingres DBA has done what she can to improve the database performance. How
can I get the best out of the Blade 100?
I believe the bottle neck is the disk performance on the 14Gb disk. We do
not want to buy a SCSI disk for this server. There is no swapping.
Would it help to use DiskSuite to mirror the Ingres data over the two disks?
Can I tweak /etc/system?
Thanks,
Richard
Spec:
640 Mb main memory
1 x 14Gb IDE HDD contains the ingress datafiles
1 x 20Gb IDE HDD contains boot, /, /var, Ingres check points
and logging.
prtmem:
Total memory: 609 Megabytes
Kernel Memory: 69 Megabytes
Application: 99 Megabytes
Executable & libs: 14 Megabytes
File Cache: 69 Megabytes
Free, file cache: 354 Megabytes
Free, free: 4 Megabytes
prtswap:
Virtual Swap:
---------------------------------------------------------------
Total Virtual Swap Configured: 2459MB
Total Virtual Swap Reserved: 129MB
Total Virtual Swap Free: (programs will fail if 0) 2330MB
Physical Swap Utilization: (pages swapped out)
---------------------------------------------------------------
Physical Swap Configured: 2000MB
Physical Swap Free (programs will be locked in if 0): 2000MB
/etc/system:
* Force Network card to 100/Full
set eri:adv_autoneg_cap=0
set eri:adv_100T4_cap=0
set eri:adv_100fdx_cap=1
set eri:adv_100hdx_cap=0
set eri:adv_10fdx_cap=0
set eri:adv_10hdx_cap=0
* Set Max page I/O operations per sec.
set maxpgio = 2048
* Added for Ingres.
set shmsys:shminfo_shmmax = 100000000
set semsys:seminfo_semmap = 300
set semsys:seminfo_semmni = 20
set semsys:seminfo_semmns = 600
set semsys:seminfo_semmsl = 100
set msgsys:msginfo_msgmax = 8192
set msgsys:msginfo_msgmnb = 16384
*******************************************************
Internet e-mail is not to be treated as a secure means
of communication. The Avon and Somerset Constabulary
monitors all internet e-mail activity and content.
This communication is confidential and intended for the
addressee(s) only. Unauthorised use or disclosure of
the content may be unlawful. Opinions expressed in
this document may not be official policy.
Thank you for your cooperation.
(C)Avon and Somerset Constabulary.
http://www.avonandsomerset.police.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:24:39 EDT