Phil,

Good question.  I vaguely recollect doing that a few years back, but I 
don't immediately see any additional indexing.  Where can I reference 
what the default indexes are supposed to be?

thanks,
Stephen



On 10/05/2015 10:28 AM, Phil Stracchino wrote:
> On 10/05/15 13:17, Stephen Thompson wrote:
>> At any rate, the only thing that's changed was the upgrade from 7.0.5 to
>> 7.2.0.  The table involved is definitely the File table.  We do have
>> jobs with 20-30 million records, so those jobs can be slow when it comes
>> time for attribute insertion into the database (or to read out a file
>> list for Accurate backups).  This why we've historically had innodb lock
>> timeout of 3600.  However, it's only last week after the upgrade that
>> we've ever had queries extend beyond that hour mark.
>
> Stephen,
> Just as a thought, there have been a number of threads on this mailing
> list recommending additional or modified indexes on the File table.
> Have you added the suggested additional indexes?
>
>

-- 
Stephen Thompson               Berkeley Seismological Laboratory
stephen AT seismo.berkeley DOT edu    215 McCone Hall # 4760
Office: 510.664.9177           University of California, Berkeley
Remote: 510.214.6506 (Tue,Wed) Berkeley, CA 94720-4760

------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users