Hi Ronan, Did you add some indices manually to your mySQL db? Looks like the first (concurrent) jobs run fast until the first finishes and updates the DB.
If the DB structure is still unmodified since Installation, this could be the problem - but I'm not sure. These changes can (should) be made after installation of 1.36.3: alter table File add index (JobId, PathId, FilenameId); alter table File add index (PathId); alter table Path drop Index Path; alter table Path add Index (Path(255)); Please report back if this solved your problems. Bye Roland -----Urspr�ngliche Nachricht----- Von: Ronan Eckelberry [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 12. Mai 2005 07:43 An: Bacula List Betreff: [Bacula-users] Question Bacula/MySQL/Large backups Hi all, I run rather large backups, about 70+ servers, 1 Full a month, rest daily incrementals. All disk -> disk backups. At the time of full backups I can be pulling anywhere from 1.5-3TB of total data from the servers. Backups start out great, pulling a few megs a piece from about 8 boxes at a time. The problem is after about 12 hours of running, MySQL shoots up to 99% CPU, which is not really a problem because it is SMP, and box is still responsive. I check the processes on mysql and it is responding to queries quickly still. Backup speed however drops to about 20k/sec from each box. It continues to run, but after awhile the director stops responding altogether and all the bacula process show as sleeping. I am forced to restart bacula and lose the backups that were unfinished. Not sure if this is because of MySQL, which seems to be operating fine, or maybe bacula, RAM, or what. Below is what the server is. I can supply configs or whatever may be needed. If anyone has any suggestions or a similar setup that had the same type of problem and was resolved, it would be appreciated. Server: Debian Woody Kernel 2.4.26 P4 2.8 HT 1G RAM 2G Swap Intel S875WP MB Thanks for any help, -Ronan ------------------------------------------------------- This SF.Net email is sponsored by Oracle Space Sweepstakes Want to be the first software developer in space? Enter now for the Oracle Space Sweepstakes! http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------- This SF.Net email is sponsored by Oracle Space Sweepstakes Want to be the first software developer in space? Enter now for the Oracle Space Sweepstakes! http://ads.osdn.com/?ad_ids93&alloc_id281&op=click _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
