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. See http://bugs.bacula.org/view.php?id=1472#c5261 for an example of problems with indexes. Grüße, Sven.
signature.asc
Description: OpenPGP digital signature
------------------------------------------------------------------------------ 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
