On 1/24/25 10:48, Bill Arlofski via Bacula-users wrote:

Hello Roberto,

Any chance you have disabled attribute spooling?  ie: `SpoolAttributes = no` in 
a Job.

This is the first thing that I can see which could inexplicably slow things 
down.  If you are monitoring the MySQL
server/service, have a look to those graphs during the Full backup run time.


Just FYI I am very unconvinced of the benefit of attribute spooling, at least with a MySQL back-end, because the spooling implementation in Bacula's MySQL driver is very bad.


(It writes attributes into a table to avoid writing them into a table, then to unspool, it reads them all out of that table and writes them into the table it otherwise would have written them to in the first place. Um ...... yeah. Quite aside from the obvious performance implications, this huge atomic write *also* makes it incompatible with Galera 3 clusters.)



--
  Phil Stracchino
  Fenian House Publishing
  ph...@caerllewys.net
  p...@co.ordinate.org
  Landline: +1.603.293.8485
  Mobile:   +1.603.998.6958


_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to