I've fixed everything, works fine now, here's the steps 1. Increase max_connections=600 /var/lib/pgsql/data/postgresql.conf 2. Increase java memory heap 4-24Gb /etc/sysconfig/tomcat6 3. Increase ulimit /etc/security/limits.conf
* soft nproc 65535 * hard nproc 65535 * soft nofile 65535 * hard nofile 65535 I found a lot of errors with a lot of opened files, no connection to DB & no heap memory On Mon, Aug 8, 2016 at 8:53 AM, Matthew Madey <[email protected]> wrote: > Are you sure it's postgres causing the issue? I run an oracle backend, but > ran into similar performance issues when attempting actions on a few > hundred systems at a time. I was able to get around this by tweaking some > of the tomcat connector settings.. This works pretty well supporting 8000+ > hosts. > > /etc/tomcat6/server.xml > > <Connector port="8080" protocol="HTTP/1.1" connectionTimeout="20000" > redirectPort="8443" URIEncoding="UTF-8" address="127.0.0.1" > maxThreads="2048" maxKeepAliveRequests="1000"/> > > > <Connector port="8009" protocol="AJP/1.3" redirectPort="8443" > URIEncoding="UTF-8" address="127.0.0.1" maxThreads="3000" backlog="200" > minSpareThreads="2000"/> > > <Connector port="8009" protocol="AJP/1.3" redirectPort="8443" > URIEncoding="UTF-8" address="::1" maxThreads="3000" backlog="200" > minSpareThreads="2000"/> > > > On Fri, Aug 5, 2016 at 5:20 PM, Konstantin Raskoshnyi <[email protected]> > wrote: > >> Hi Guys, >> >> Got this problem - We have around 700 hosts, and pretty powerful sp >> server - 32cores, 64g of ram. >> >> When I push to install a package to > than 100 hosts , our sp is busted. >> Looks like postgres in not multithreaded and it sucks all life out of the >> server. I optimized postgres config but i doesn't help. >> >> Any cases how to manage a lot of machines with sp? >> >> Thanks >> >> _______________________________________________ >> Spacewalk-list mailing list >> [email protected] >> https://www.redhat.com/mailman/listinfo/spacewalk-list >> > > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list >
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
