On 10/02/17 07:30, Sven Hartge wrote: > On 02.10.2017 06:03, Phil Stracchino wrote: > >> While answering a user question the other day on identifying files that >> span tape boundaries, I extended one of the indexes on the File table: >> >> >> MySQL localhost> alter table File drop index PathId, add index PathId >> (PathId, FilenameId, FileIndex); >> >> >> This change has MASSIVELY sped up the 'purge volume' operation. Purges >> that used to take four or five minutes now complete in 20 to 30 seconds. > > Have you checked if this slows down the attribute INSERT operation after > each backup or any other operation? > > It may help speed up the purge operation for the tape but it is on the > other hand of no use if it slows down the attribute insertion, which > happens much more often.
I haven't, no, and this would be a difficult thing to measure accurately because I turned off attribute spooling (because as currently implemented, it prevents Bacula from working at all on Galera clusters and is of dubious value on MySQL at best), so there is no massive blast of attribute insertions at end-of-job to time. I have a full backup running right now and I am not seeing a performance issue; attributes are being streamed into the database as the job runs with no backlog evident. The DB appears to be storing the attributes faster than the servers being backed up can stream the files. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
