[Spacewalk-list] Systems Overview Slow for +1k Instances

[Reed, Steven]

The systems query is very intensive on the DB.  How is your oracle db server performing.  Also you may want to add more vcpu vram to the spacewalk server or increase the number of db connections.

Out of curiousity why have so many proxies ?  i’m surprised your master returns that query at all ;)  if they are all remote sites I prefer to have a spacewalk instance at each location or at least minimise the use of proxies.  It’s not a “single pane of glass” so to speak but makes troubleshooting/management and tuning much easier.  Performance is obviously way better with spacewalk managing less hosts per instance.

From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Andy Seed
Sent: Wednesday, 9 September 2015 7:12 AM
To: spacewalk-list at redhat.com
Subject: [Spacewalk-list] Systems Overview Slow for +1k Instances

Hi,

I'm wondering if anybody has experienced slow lag accessing the Systems tab in the Web UI.

We are using Oracle Linux 6.5 for our Spacewalk master with the Oracle Spacewalk 2.2 release. We have multiple Spacewalk proxies, each will manage 1k instances up to a total of 6 proxies. We have a separate Oracle db server running 11G R2. What we are seeing is a long lag when accessing the Systems Overview page.

We've tried all the standard tuning for Java and tomcat, all the recommended tuning for Spacewalk and Satellite configurations with no change.

When we have 100 OL instances registered it takes 5 sec flicking between Overview and the Systems tab.

When we increase this to 350 OL instances we see the lag jump to 15 secs, then increasing up to 1100 OL instances this lag is up to 70 secs. This is not going to be workable when we start increasing to +5k instances.

Thanks in advance
Andy

________________________________
This email (including any attachments) may contain confidential and/or legally privileged information and is intended only to be read or used by the addressee(s). If you have received this email in error, please notify the sender by return email, delete this email and destroy any copy. Any use, distribution, disclosure or copying of this email by a person who is not the intended recipient is not authorised.

Views expressed in this email are those of the individual sender, and are not necessarily the views of Transport for NSW, Department of Transport or any other NSW government agency. Transport for NSW and the Department of Transport assume no liability for any loss, damage or other consequence which may arise from opening or using an email or attachment.
Please visit us at http://www.transport.nsw.gov.au or http://www.transportnsw.info
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20150909/c3de0df2/attachment.htm>