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?


-- 
  Phil Stracchino
  Babylon Communications
  phils AT caerllewys DOT net
  phil AT co.ordinate DOT org
  Landline: 603.293.8485

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