[Spacewalk-list] How to improve WUI performance

[Ree, Jan-Albert van]

A few things to look at :

- if you have the database and the web frontend on the same machine , 4 GB to me sounds very minimal... PostgreSQL will become much quicker if it can cache more data so you might want to add some RAM (go to 6 or 8 GB and maybe tweak your PostgreSQL configuration a bit) When we were still running virtual the web frontend machine had 8 GB and the PostgreSQL VM had 8 GB, both with 2 cores and things ran fine (granted, with only roughly 70 clients)

- for us OSA became a lot smoother and more stable by switching it's backend from berkeley DB to SQLite ; I'd recommend this step to everybody using OSA. See https://www.redhat.com/archives/spacewalk-list/2011-March/msg00048.html on how to do this.​

- you might want to check if the machine is hitting I/O limits ; tools like vmstat can help a lot


More CPU's doesn't sound like the solution, as only one core is pegged at 100% ; memory, disk I/O and maybe if it's a remote PostgreSQL instance network sound like more likely candidates.

--

Jan-Albert


Jan-Albert van Ree | Linux System Administrator | MARIN Support Group
MARIN | T +31 317 49 35 48 | J.A.v.Ree at marin.nl<mailto:J.A.v.Ree at marin.nl> | www.marin.nl<http://www.marin.nl>

[LinkedIn]<https://www.linkedin.com/company/marin> [YouTube] <http://www.youtube.com/marinmultimedia>  [Twitter] <https://twitter.com/MARIN_nieuws>  [Facebook] <https://www.facebook.com/marin.wageningen>
MARIN news: Software seminar in Shanghai for the first time<http://www.marin.nl/web/News/News-items/Software-seminar-in-Shanghai-for-the-first-time.htm>

________________________________
From: spacewalk-list-bounces at redhat.com <spacewalk-list-bounces at redhat.com> on behalf of Daryl Rose <darylrose at outlook.com>
Sent: Thursday, October 13, 2016 16:54
To: spacewalk-list at redhat.com
Subject: [Spacewalk-list] How to improve WUI performance


I have 465 servers in my SW environment, and I keep adding more everyday.  When finished, I'll have nearly a thousand servers in the environment.


My SW server is a virtual RHEL 6.6, SW v2.3.  I have four CPU's and four Gigs of memory allocated to the server.


Whenever I select "Systems" from the main menu a single CPU pegs at 100%, and it takes several minutes for the page to come up.  It appears that osa-dispatcher is what is using up the CPU.  osa-dispatcher is often at 99 to 100%.


Is there  a way to performance tune SW?  Can I configure SW to use all four CPU's, or should I add additional CPU's, can configure SW to use all assigned CPU's?


Thanks


Daryl


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20161013/43a78c87/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image11bc0e.PNG
Type: image/png
Size: 293 bytes
Desc: image11bc0e.PNG
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20161013/43a78c87/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: imagee95bb6.PNG
Type: image/png
Size: 331 bytes
Desc: imagee95bb6.PNG
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20161013/43a78c87/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image4e3140.PNG
Type: image/png
Size: 333 bytes
Desc: image4e3140.PNG
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20161013/43a78c87/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image1ea6dc.PNG
Type: image/png
Size: 253 bytes
Desc: image1ea6dc.PNG
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20161013/43a78c87/attachment-0003.png>