[Spacewalk-list] Repo Sync speed problem

[Jeremy Davis]

On Wed, Aug 17, 2011 at 12:54 PM, Jan Pazdziora <jpazdziora at redhat.com>wrote:

> On Wed, Aug 17, 2011 at 09:18:25AM -0600, Jeremy Davis wrote:
> > Hello All,
> >
> > I have this issue with slowness but the index does exist. It is somewhat
> > quick for repositories that only hve like 2 or 3 package but repositories
> > that have more than 300 it takes a while to process new packages. Any
> ideas
> > as to what might be the cause? Thank you for your time and have a great
> day!
>
> You should find out if it's the database or something else where
> most CPU time is spent, and if it's the database system, find out
> which query it spends its cycles. Then get the execution (explain) plan
> for the query and see if it could be made faster.
>
>
>
 Hello Jan,

It appears to be the Spacewalk-repo-sync and Java applications that are
taking up the most CPU time when performing yum repository syncs. The
database almost looks like it is idle. The database server is a standalone
server.

Regards,
Jeremy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110822/509ef426/attachment.htm>