[Spacewalk-list] Spacewalk performance issues

[Konstantin Raskoshnyi]

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 <mattmadey at gmail.com> 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 <konrasko at gmail.com>
> 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
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20160808/b37ec520/attachment.htm>