Re: [Bacula-devel] MySQL indexes

2017-10-02 Thread Phil Stracchino
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, a

Re: [Bacula-devel] MySQL indexes

2017-10-02 Thread Sven Hartge
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, FileIn

[Bacula-devel] MySQL indexes

2017-10-01 Thread Phil Stracchino
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 volu