SUMMARY: Ingres performance on a Sun Blad e 100

Hi,

Thanks to Kevin Buterbaugh, Rob Rugman, Hichael Morton, Doug Otto and
Tristan Ball for their replies and suggestions.

Mirroring over two IDE disks on one bus would, it seems, make matters worse.
IDE won't support the throughput to make the difference I was looking for. 

I started logging the output from "iostat -xtc", "mpstat" and "vmstat" along
with working the disks very hard (dd if=/dev/zero of=<a file> bs=1024k
count=1024" and also "if=<the file> of=/dev/null") for a load test and found
that the disks were really only doing about 10% of that load during normal
running. 

My conclusion is that the server is working fine but moving from two CPUs to
one and two Ingres server processes to one is the real cause of the
performance drop rather than any other aspect of the hardware downgrade.

Thanks,

Richard


============================================================================
========

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