There was a post a while back which gives you the recommended settings for Apache. Apache is very slow for Web2py and other python projects. nginx is much better.
On Saturday, April 5, 2014 9:37:59 AM UTC-7, Francisco Betancourt wrote: > > I have not tuned Apache nor Postgres, their both vanilla installs through > APT. I don't have the top or iostat output right now, I will simulate the > load tomorrow that users don't work on the app and post back on monday. I > will also enable PostgreSQL statistics and post them too. Thanks for the > help. > > El viernes, 4 de abril de 2014 21:14:32 UTC-6, LightDot escribió: >> >> On Friday, April 4, 2014 7:14:39 PM UTC+2, Francisco Betancourt wrote: >>> >>> Hello LightDot >>> >>> Thanks for the interest in my post, hope we can come up with a way to >>> improve performance. This is my current setup: >>> >>> >>> - Host: Digital Ocean (and yes I do think their Droplets (as >>> instances are called) are KVM) >>> - OS: Ubuntu 13.04 >>> - Web Server: Apache 2.2 >>> - Database: PostgreSQL 9.1 >>> - Memory usage in peak times is about 1.4GB (out of 2GB) >>> - By the way I have no swap partition >>> - I don't know how to count db connections, but in my db definition >>> I used the poolsize=50, but again I don't know how to check the amount >>> of >>> connections at any given time >>> - Disk usage acording to Digital Ocean metrics is medium never high >>> (do truly I have never understand their graph) >>> - CPU usage at some points gets close to 50% (since this a dual core >>> I would assume one of the cores is at 100%) >>> >>> I don't know what else to mention but, if I missed anything please ask. >>> And thanks again. >>> >> >> This is good information to start with. Do you have more statistics, such >> as top and iostat output at the peak times, etc. ? >> >> Postgresql itself has statistics available, for example see >> http://www.postgresql.org/docs/9.1/static/monitoring-stats.html >> >> Did you already tune apache or postgresql in any way? if so, what are >> your settings..? On the web2py side and for your current use case, the >> poolsize=50 setting might be ok or not, depending on your apache/pg setup... >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
