From: Richard Mackerras (richard.mackerras@avonandsomerset.police.uk)
Date: Mon Jul 29 2002 - 07:55:29 EDT
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
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:24:40 EDT