[Spacewalk-list] compare-configs-default (compare-config-bunch) - DB high CPU usage

[William H. ten Bensel]

Is there any way to reduce the CPU usage via a configuration change (ie 
only schedule on % servers during these specified times), batch run time 
change, or increase the time between the scheduled tasks for each server?
Any other ideas/suggestions on how to reduce the CPU usage for this task?

- Thanks in advance


Issue:
        CPU performance issues (90 - 100% usage) on external Oracle 11G 
Database server when the Administrator task compare-configs-default 
(compare-config-bunch) is ran.  SQL information below.
        Previous related issue: 
https://www.redhat.com/archives/spacewalk-list/2013-August/msg00016.html 
where the job was disabled.

Current work around:
 
         Admin -> Task Schedules -> compare-configs-default 
(compare-config-bunch) : disabled

Configuration:
        Application: Spacewalk 2.3

        Registered Servers: 8k+

        Task job: compare-configs-default scheduled at 23:00 daily

        Orgs : 2
        Config Channels per org: 11
        Config files per org: 34 
        Largest config file: 64KB


        External DB Hardware:
                processor_hyperthreading : disabled
                processor_num_cores : 8
                processor_num_sockets : 2
                processor_total : 16
                processor_speed : 2400 MHz
                memory_RAM: 32 G

        Spacewalk 2.3 Hardware:
                processor_hyperthreading : enabled
                processor_num_cores : 6
                processor_num_sockets : 2
                processor_total : 24
                processor_speed : 2000 MHz
                memory_RAM: 32 G


SQL Information:

select cfn.path, cc.label config_channel, ccont.contents file_contents, 
ccont.is_binary is_binary, c.checksum_type, c.checksum, ccont.delim_start, 
ccont.delim_end, cr.revision, ci.username, ci.groupname, ci.filemode, 
cft.label, ci.selinux_ctx, case when cft.label='symlink' then
(select path
from rhnConfigFileName
where id = ci.SYMLINK_TARGET_FILENAME_ID) else '' end as symlink
from rhnConfigFileState cfs, rhnConfigChannel cc, rhnConfigFileName cfn, 
rhnConfigInfo ci, rhnConfigFile cf, rhnConfigRevision cr left join 
rhnConfigContent ccont on cr.config_content_id = ccont.id left join 
rhnChecksumView c on ccont.checksum_id = c.id, rhnConfigFileType cft, 
rhnActionConfigRevision acr
where acr.server_id = :server_id and acr.action_id = :action_id and 
acr.config_revision_id = cr.id and cr.config_file_id = cf.id and 
cr.config_info_id = ci.id and cf.config_file_name_id = cfn.id and 
cf.config_channel_id = cc.id and cf.state_id = cfs.id and cfs.label = 
'alive' and cr.config_file_type_id = cft.id 


http://spacewalk.redhat.com/documentation/schema-doc/view-RHNUSERACTIONOVERVIEW.html

ACTION_STATUS
----------------
Queued
Picked Up
Failed
Completed


SQL> select count(*) from RHNUSERACTIONOVERVIEW where 
ACTION_STATUS='Queued';
Press return to continue

  COUNT(*)
----------
     21768

**

This email and any attachments may contain information that is confidential and/or privileged for the sole use of the intended recipient.  Any use, review, disclosure, copying, distribution or reliance by others, and any forwarding of this email or its contents, without the express permission of the sender is strictly prohibited by law.  If you are not the intended recipient, please contact the sender immediately, delete the e-mail and destroy all copies.
**
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20151216/ee47fb2d/attachment.htm>