[Spacewalk-list] Repo Sync speed problem

[pradelles nicolas]

We use Oracle as database backend, client version 11.2.0.2 on Spacewalk server and 10.2.0.4 on external AIX Oracle server.

After checking with a DBA, the Oracle server is very CPU stressed by the reposync script, specially by the following SQL command:
---
select /*+index(rhnPackageCapability rhn_pkg_cap_name_version_uq)*/ id from rhnPackageCapability where name = :name and version is null
---

It seems the script is reading continuously the table "rhnPackageCapability" to search file path (column "name"). As there is no index on this column (quite normal for a filepath list), the "select" is parsing the +2'000'000 lines of the table at each select.


We are currently creating a test base to check different "optimizer_mode" parameters.



-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Jan Pazdziora
Sent: mardi 16 août 2011 15:25
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Repo Sync speed problem

On Tue, Aug 16, 2011 at 03:08:54PM +0200, pradelles nicolas wrote:
> Hello,
> I am actually using Spacewalk 1.5 on an RHEL 6.1 server in KVM with 2 
> vCPUS & 4GB RAM, with a MREPO external server to sync RHN and external 
> channels (EPEL, Jpackage, HP Proliant Support Pack ...)
> 
> Since first installation, the "spacewalk-reposync" task is extremly 
> slow. Actually I am synchronizing the RHEL5 EPEL and after 3 hours 
> only
> 61 packages on 5390 have been imported from MREPO server in Spacewalk 
> server. Sometimes reposync wait 20 minutes between 2 packages download.
> I don't see any relevant problems in log files on Spacewalk or MREPO 
> servers :(

What database backend is this? What is in the top as the top CPU-consuming process?

--
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

This message may contain confidential or privileged information and is 
intended only for the personal and confidential use of the designated
recipient(s) named above. If you are not one of the intended recipients 
of this message you are hereby notified that any review, dissemination, 
distribution or copying is strictly prohibited. 
This communication is for information purposes only and should not be 
regarded as an official statement of Eutelsat S.A. or any of its 
subsidiaries. E-mail transmission cannot be guaranteed to be secure or 
error-free. Therefore, Eutelsat S.A. does not claim that this information
is complete or accurate and it should not be treated as such.