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 step...@seismo.berkeley.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
