[Babase] Hunter-Karl phone call

Karl O. Pinc kop at meme.com
Tue May 15 16:01:06 EDT 2007


Hunter,

Take a look.

On 05/15/2007 02:28:00 PM, Lacey Maryott wrote:
> How did we make out Karl?

Well, good and bad.

We were unable to crash Postgres.  We did wind up using a whole
boatload of swap (about 5.5G of our 6G).

It seems that running bad queries does not make the system
so unresponsive that it becomes unusable.  Other queries
seem to get a fair share.

We were doing tons of swapping, over 5,000 swaps, both in
and out/sec.  The good news is that the CPU was still
the limiting factor, so that does not matter too much.

The bad part is that when we finally finished the stress test
we didn't get the swap back.  One of the apache children
still has it.

Hunter, what to do?  Cut down on the number of requests
served per child?  Get a new-er apache?

I'm thinking that if we don't crash we don't care, so maybe
we just hope that we don't crash and worry about it should
the day come.


top - 15:51:54 up 124 days, 22:32,  7 users,  load average: 0.59, 1.06,  
1.75
Tasks: 111 total,   1 running, 106 sleeping,   4 stopped,   0 zombie
Cpu(s):  0.0% us,  0.3% sy,  0.0% ni, 99.0% id,  0.7% wa,  0.0% hi,   
0.0% si
Mem:   2075784k total,  2071464k used,     4320k free,     2884k buffers
Swap:  6225904k total,  5705172k used,   520732k free,   511712k cached



[kop at papio conversion]$ ps axv | egrep '(postgres)|(http)'
  4423 pts/3    S      0:02     16  2547  6480  220  0.0 postgres:  
logger process
  4425 pts/3    S      1:53   8597  2547 944380 5884  0.2 postgres:  
writer process
  4426 pts/3    S      0:00    299  2547  7484  164  0.0 postgres:  
stats buffer process
  4427 pts/3    S      0:00    165  2547  6616  416  0.0 postgres:  
stats collector process
  6616 ?        Ss     0:00     64   245 19686  800  0.0 /usr/sbin/httpd
  9026 ?        S      1:27  57786   245 3066138 10732  0.5  
/usr/sbin/httpd
  9027 ?        S      7:35   5581   245 29262 9340  0.4 /usr/sbin/httpd
  9028 ?        S      0:11    778   245 29246 5400  0.2 /usr/sbin/httpd
  9029 ?        S     17:06  12964   245 29402 9120  0.4 /usr/sbin/httpd
  9030 ?        S      0:47  56951   245 3065638 948148 45.6  
/usr/sbin/httpd
  9031 ?        S      0:08    292   245 29558 9852  0.4 /usr/sbin/httpd
  9032 ?        S      4:02  11099   245 25502 5844  0.2 /usr/sbin/httpd
  9033 ?        S      0:09    987   245 25554 6200  0.2 /usr/sbin/httpd
29054 ?        S      0:01    802   245 24754 9152  0.4 /usr/sbin/httpd
29065 ?        S      3:03   2416   245 24886 9704  0.4 /usr/sbin/httpd
29066 ?        S      0:01   1001   245 22322 6884  0.3 /usr/sbin/httpd
29067 ?        S      0:01   1097   245 24810 9796  0.4 /usr/sbin/httpd
29068 ?        S      0:03   3734   245 22194 7088  0.3 /usr/sbin/httpd
29747 pts/4    S+     0:00      0    71  5056  712  0.0 egrep  
(postgres)|(http)


Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list