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