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.
