24 messages in com.googlegroups.pylons-discussRe: advice with configuration/scaling...
FromSent OnAttachments
SamDonaldson28 May 2008 13:27 
Jonathan Vanasco28 May 2008 14:04 
SamDonaldson28 May 2008 14:24 
Jonathan Vanasco28 May 2008 14:39 
SamDonaldson28 May 2008 15:11 
Jonathan Vanasco28 May 2008 16:47 
Paweł Stradomski28 May 2008 23:55 
Alex Marandon29 May 2008 00:43 
Alex Marandon29 May 2008 02:28 
Ian Bicking29 May 2008 09:04 
Graham Dumpleton29 May 2008 16:29 
Mike Orr29 May 2008 19:56 
Graham Dumpleton30 May 2008 00:49 
Alex Marandon30 May 2008 05:12 
Jonathan Vanasco30 May 2008 07:17 
Jonathan Vanasco30 May 2008 07:20 
Shannon -jj Behrens30 May 2008 11:03 
Shannon -jj Behrens30 May 2008 11:19 
Ben Bangert30 May 2008 12:03 
Jonathan Vanasco30 May 2008 12:27 
Cliff Wells30 May 2008 12:35 
Mike Orr30 May 2008 14:29 
askel31 May 2008 03:27 
SamDonaldson31 May 2008 16:33 
Subject:Re: advice with configuration/scaling a live Pylons app.
From:SamDonaldson (samo@gmail.com)
Date:05/28/2008 03:11:39 PM
List:com.googlegroups.pylons-discuss

Yes, lighttpd serving static and all dynamic requests forwarded to the paster process talking SCGI. Should I make the switch to nginx as it seems like everybody has something good to say about nginx, and it's a good load balancer.

Also, is the fact that I'm only running a single paster process a problem? I remember iwth RoR, mongrel started multiple child processes.

Thanks.

On May 28, 2:39 pm, Jonathan Vanasco <jona@findmeon.com> wrote:

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?