[Spacewalk-list] massive transactions on dist import

[Michael Mraka]

Marcus Moeller wrote:
% Dear Michael.
% 
% > % > we have noticed that a distribution import (e.g. full F11 64bit) causes a huge oracle transaction log (about 50GB). The database itself has a size of about 7GB atm.
...
% > I was talking about the archive log.

Hi Marcus,

I'm sorry I haven't looked at it yet.

% As the size of the archive.log results in the number of commits and
% nearly every update is committed separately the file grows
% continuously. During import we got about 800 MB archive.log within 3
% minutes.

BTW how was import done? Using spacewalk-repo-sync or rhnpush?

% We have tried to set hibernate.jdbc.batch_size=20 in
% /etc/rhn/default/rhn_hibernate.conf but settings seems to be
% overwritten by the application.

% Best Regards
% Marcus

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat