Re: advice with configuration/scaling a live Pylons app. - Jonathan Vanasco - com.googlegroups.pylons-discuss

24 messages in com.googlegroups.pylons-discussRe: advice with configuration/scaling...

From	Sent On	Attachments
SamDonaldson	28 May 2008 13:27
Jonathan Vanasco	28 May 2008 14:04
SamDonaldson	28 May 2008 14:24
Jonathan Vanasco	28 May 2008 14:39
SamDonaldson	28 May 2008 15:11
Jonathan Vanasco	28 May 2008 16:47
Paweł Stradomski	28 May 2008 23:55
Alex Marandon	29 May 2008 00:43
Alex Marandon	29 May 2008 02:28
Ian Bicking	29 May 2008 09:04
Graham Dumpleton	29 May 2008 16:29
Mike Orr	29 May 2008 19:56
Graham Dumpleton	30 May 2008 00:49
Alex Marandon	30 May 2008 05:12
Jonathan Vanasco	30 May 2008 07:17
Jonathan Vanasco	30 May 2008 07:20
Shannon -jj Behrens	30 May 2008 11:03
Shannon -jj Behrens	30 May 2008 11:19
Ben Bangert	30 May 2008 12:03
Jonathan Vanasco	30 May 2008 12:27
Cliff Wells	30 May 2008 12:35
Mike Orr	30 May 2008 14:29
askel	31 May 2008 03:27
SamDonaldson	31 May 2008 16:33

Subject:	Re: advice with configuration/scaling a live Pylons app.
From:	Jonathan Vanasco (jona...@findmeon.com)
Date:	05/28/2008 02:39:06 PM
List:	com.googlegroups.pylons-discuss

On May 28, 5:24 pm, SamDonaldson <samo...@gmail.com> wrote:

Yes, we've profiled the db. Are you asking because of the concern over failed requests in the ab benchmark test?

1- The first bottleneck anyone hits is the usually the DB 2- You can get some idea of how connection pooling is working off the db. In postgres you can do 'select * from pg_stat_activity' to check on connections and what they're doing. There are a few ways to tweak for performance and analysis reporting too. it's been years since i've touched mysql, so i can't comment on that.

Just to make sure... you have lighttpd serving the static content, right?