<span id="result_box" class="long_text"><span style="background-color: rgb(255, 255, 255);" title="Gracias por el link y por contestar." onmouseover="this.style.backgroundColor='#ebeff9'" onmouseout="this.style.backgroundColor='#fff'">Thanks for the link and answer.
<br>
<br></span><span style="background-color: rgb(255, 255, 255);" title="Por el momento hice tunning ¬¬!" onmouseover="this.style.backgroundColor='#ebeff9'" onmouseout="this.style.backgroundColor='#fff'">At the moment did tunning ¬ ¬! </span><span style="background-color: rgb(255, 255, 255);" title=", bueno mejor dicho a prueba y error." onmouseover="this.style.backgroundColor='#ebeff9'" onmouseout="this.style.backgroundColor='#fff'">, Well better said a trial and error. </span><span style="background-color: rgb(255, 255, 255);" title="Tengo esta configuración que al parecer funciona por lo menos lleva un dia sin fallar." onmouseover="this.style.backgroundColor='#ebeff9'" onmouseout="this.style.backgroundColor='#fff'">I have this configuration seems to work at least take a day without fail.
</span></span><br><br><br><span id="result_box" class="short_text"><span style="background-color: rgb(255, 255, 255);" title="Les dejo mis configuraciones por si a alguien le funciona por mas dias.">I leave my settings if anyone would work for more days.</span></span><br>
<br>Postgres with 4gigas<br>#####Set this to 140% of the average number of expected connections. 100 clients average means 140 max connections.<br>max_connections = 2000<br>tcp_keepalives_idle = 60 # TCP_KEEPIDLE, in seconds;<br>
# 0 selects the system default<br>tcp_keepalives_interval = 30 # TCP_KEEPINTVL, in seconds;<br> # 0 selects the system default<br>tcp_keepalives_count = 10 # TCP_KEEPCNT;<br>
# 0 selects the system default<br><br>shared_buffers = 262144 # min 16 or max_connections*2, 8KB each<br>#2 Gigas<br>#echo $((1024 * 1024 * 3072)) > /proc/sys/kernel/shmmax<br>
#262144=1024*1024*3072/8192<br>work_mem = 16384<br>max_fsm_pages = 153600 # min max_fsm_relations*16, 6 bytes each<br>#GuyThornley's favourite settings for these parameters are:<br>commit_delay = 20000<br>
commit_siblings = 3<br>effective_cache_size = 393216<br>random_page_cost = 4 # units are one sequential page fetch<br><br><br>To Plone 4 gigas<br> zserver-threads 6<br>%import relstorage<br> <relstorage><br>
name BDplone<br> blob-dir var/blobs<br> cache-local-mb 512<br> cache-delta-size-limit 10000<br> commit-lock-timeout 30<br> poll-interval 0<br> pack-dry-run true<br> pack-batch-timeout 5.0<br>
pack-duty-cycle 1.0<br> pack-max-delay 20<br> <postgresql><br> dsn dbname='BDplone' user='admin' host='10.9.10.33' password='123'<br> </postgresql><br>
</relstorage><br> mount-point /<br></zodb_db><br><br><br><br><br><div class="gmail_quote">2010/4/19 Laurence Rowe <span dir="ltr"><<a href="mailto:l@lrowe.co.uk">l@lrowe.co.uk</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">I've had this issue reported to me in the context of zope.sqlalchemy,<br>
but have been unable to reproduce it. Others have also seen it, but as<br>
far as I am aware have not been able to reproduce it:<br>
<a href="http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg146522.html" target="_blank">http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg146522.html</a><br>
<br>
As there have now been three sightings, in the context of SQLAlchemy,<br>
Django, and plain dbapi2 usage (RelStorage). I suspect it is a real<br>
issue with Psycopg2, however until it can be reproduced I'm not<br>
hopeful it can be fixed.<br>
<br>
Laurence<br>
<br>
On 19 April 2010 19:34, lista administracion <<a href="mailto:reference.list@gmail.com">reference.list@gmail.com</a>> wrote:<br>
</div><div><div></div><div class="h5">> Hi<br>
><br>
> We have two servers with Plone that point to the same database [Postgres 8]<br>
> so that if one fails the other working.<br>
><br>
> The problem is that at least once a day left to answer my Plone few minutes<br>
> (it is in white or takes a long to respond)<br>
> and cause apache send Proxy Error, this is solved but it is only annoying<br>
> for we users to wait 5 to 10 minutes not counting the lack of availability<br>
> of the page.<br>
><br>
> We find that when it fails, PostgreSQL maintains a connection and keeps a<br>
> long time as "in transaction" and after about 10 minutes this connection<br>
> automatically terminates. this causes plone fail,at least 10 minutes<br>
><br>
> The solution restart plone or kill the process as follows<br>
><br>
> postgres 23267 0.0 0.1 2172016 7768 ? S 10:17 0:00 postgres:<br>
> ploneadmin plonetesting 10.9.33.116(45189) idle in transaction<br>
> kill -15 23267<br>
><br>
><br>
> We have<br>
> 2 Servers with Apache/Plone<br>
> Ram 4 Gigas<br>
> RedHat 5.4<br>
> Apache 2.2.3<br>
> Plone 3.3.4<br>
> RelStorage-1.4.0b3<br>
><br>
> 1 Server with Postgres<br>
> Ram 4 Gigas<br>
> RedHat 5.4<br>
> Postgres 8.1.18<br>
><br>
> Configuration.<br>
><br>
> -- Conexion DB<br>
> <relstorage><br>
> blob-dir var/blobs<br>
> <postgresql><br>
> dsn dbname='plone' user='admin' host='10.9.33.128'<br>
> password='password123'<br>
> </postgresql><br>
> </relstorage><br>
><br>
> Recently modify these parameters in both servers and now it takes about 3<br>
> days to fail.<br>
><br>
> blob-dir var/blobs<br>
> cache-local-mb 512<br>
> cache-prefix prod<br>
> cache-delta-size-limit 5000<br>
> commit-lock-timeout 10<br>
> poll-interval 60<br>
> pack-dry-run true<br>
> pack-batch-timeout 8<br>
> pack-duty-cycle 0.3<br>
> pack-max-delay 30<br>
><br>
> We do not know if the problem is plone, postgres or network<br>
> I hope someone can advise something.<br>
><br>
> thanks in advance.<br>
><br>
</div></div><div><div></div><div class="h5">> _______________________________________________<br>
> For more information about ZODB, see the ZODB Wiki:<br>
> <a href="http://www.zope.org/Wikis/ZODB/" target="_blank">http://www.zope.org/Wikis/ZODB/</a><br>
><br>
> ZODB-Dev mailing list - <a href="mailto:ZODB-Dev@zope.org">ZODB-Dev@zope.org</a><br>
> <a href="https://mail.zope.org/mailman/listinfo/zodb-dev" target="_blank">https://mail.zope.org/mailman/listinfo/zodb-dev</a><br>
><br>
><br>
</div></div></blockquote></div><br>