[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