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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
