Performance Problem 
Author Message
 Performance Problem

I have an IBM rs6000 (4x166 processors) and 1.5 G Ram  running Informix
7.24.  The problem is that unless I cripple Informix using the SHMTOTAL
directive in the onconfig (set to 700M) the system goes so slow that no one
can use it, which also results in AIX reporting fork failures due to
insufficient memory.
If I let Informix do its own thing and set SHMTOTAL to zero (unlimited)
Informix appears to allocate far more memory than it needs to, all stats
appear normal.

In addition if I up the BUFFERS to a point where the Informix instance uses
for than 500M of memory I also get the same problem.

If anyone has come across this problem I would love to hear from you.

Regards

Callum




Wed, 18 Jun 1902 08:00:00 GMT
 Performance Problem


Quote:

>I have an IBM rs6000 (4x166 processors) and 1.5 G Ram  running Informix
>7.24.  The problem is that unless I cripple Informix using the SHMTOTAL
>directive in the onconfig (set to 700M) the system goes so slow that no one
>can use it, which also results in AIX reporting fork failures due to
>insufficient memory.
>If I let Informix do its own thing and set SHMTOTAL to zero (unlimited)
>Informix appears to allocate far more memory than it needs to, all stats
>appear normal.

>In addition if I up the BUFFERS to a point where the Informix instance uses
>for than 500M of memory I also get the same problem.

>If anyone has come across this problem I would love to hear from you.

Post output from

onstat -c
onstat -g seg (preferably when you're having the problem)

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.



Wed, 18 Jun 1902 08:00:00 GMT
 Performance Problem

Our config, RS/6000 model H70 with 2x 334 processors and 768MB ram,
vmstat showed huge amounts of memory gone after a few hours...

The solution... ibm's filesystem cache, reduce the load using
vmtune poof, memory loss gone. Now we have some memory leaks elsewhere
but those I'll find.

brett

Quote:

> I have an IBM rs6000 (4x166 processors) and 1.5 G Ram  running Informix
> 7.24.  The problem is that unless I cripple Informix using the SHMTOTAL
> directive in the onconfig (set to 700M) the system goes so slow that no one
> can use it, which also results in AIX reporting fork failures due to
> insufficient memory.
> If I let Informix do its own thing and set SHMTOTAL to zero (unlimited)
> Informix appears to allocate far more memory than it needs to, all stats
> appear normal.

> In addition if I up the BUFFERS to a point where the Informix instance uses
> for than 500M of memory I also get the same problem.

> If anyone has come across this problem I would love to hear from you.

> Regards

> Callum



--

-----------------------------------------------------------------
            Brett's ninth law of UNIX administration...
                   Ye shall read the words:
           http://cm.bell-labs.com/who/ken/index.html
           http://cm.bell-labs.com/who/dmr/index.html
-----------------------------------------------------------------
Brett Geer - UNIX Admin/Analyst/Programmer - Intratex Holdings.
Tel. +27 31 717 4000 Direct. +27 31 717 4146
Fax. +27 31 717 4001
-----------------------------------------------------------------
        If you have any trouble sounding condescending,
        find a Unix user to show you how it's done.
                    --Scott Adams
-----------------------------------------------------------------



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. SQL Server Performance Problem - Good query performance, bad update performance

2. Solution on Performance Problems Needed

3. HELP! Performance Problem

4. Performance Problems with Linked Server

5. performance problems in sql server 2000

6. performance problem - procedure called with insert into

7. Asp performance problem at recordset movenext

8. Performance Problems (Stored Procedure)

9. Performance problems

10. Performance problems VB6 ADO WIn 9x

11. Another performance problem with SQL7


 
Powered by phpBB® Forum Software