Re: Performance issue
Phil Stracchino <[email protected]>
| Newsgroups | gmane.comp.bacula.user |
|---|---|
| Organization | Fenian House Publishing |
| Message-ID | <[email protected]> |
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 [email protected] [email protected] Landline: +1.603.293.8485 Mobile: +1.603.998.6958