Zitat von Carsten Pache <pache AT vgr-gruppe DOT de>:
>> >> An additional option is that after upgrading the database server it
>> >> returned to the default database config file which in a lot of cases
>> >> is optimized for machines with a few MB (yes MB) of memory.
>> >
>> > I do not remember that I had to change the defaut database
>> > configuration when I installed Bacula 5.0.3 two years ago. So which
>> > config file do you mean? Can you give me some hints what I should
>> > change in this file? My Bacula server has 2 GB RAM.
>>
>> For a high insert rate you normaly have to extend the size or number
>> of redo logs. For MySQL this might be possible in /etc/my.cnf or the
>> like but i don't use MySQL so you have to RTFM.
>
> What confuses me is that the part of the backup job that fetches the
> files from the server takes nearly as long as before, but the
> sending of the spooled attributes to the Director takes extremely
> long (Bacula 5.0.3: 3 minutes, Bacula 5.2.5: 7 hours 45 minutes). If
> the current (new) config of MySQL is not suitable, then I would
> expect that everything slows down.
>
> I will take a look into the MySQL manual, but as the Bacula server
> is responsible for backup only, it might be faster to setup the
> server from scratch.
If you can afford do a setup from scratch. There was at least one bug
in the upgrade process of Ubuntu/Debian regarding the database. I
really doubt that tunning the database will get you down from more
than 7 hours to something useable, so something other must be horrible
wrong.
Regards
Andreas
------------------------------------------------------------------------------
LogMeIn Central: Instant, anywhere, Remote PC access and management.
Stay in control, update software, and manage PCs from one command center
Diagnose problems and improve visibility into emerging IT issues
Automate, monitor and manage. Do more in less time with Central
http://p.sf.net/sfu/logmein12331_d2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
