On 09/15/15 04:24, Craig Shiroma wrote:
> Yes, the database is large.  The File table has 370+ million records and
> Bacula is pruning.  I'll see what we can do with mysqltuner.  I have a
> feeling I'm occasionally getting the timeout error because there are so
> many records.  If I can't find a cure for the situation, I'm thinking of
> splitting up our backups using two catalog servers -- one for production
> and one for test/dev.  Do you think this is wise?


Are you using InnoDB?  Are you properly configured for InnoDB?  If not,
you should be.  MyISAM tables really should not be used in production
any more, and Oracle is moving towards deprecating the MyISAM engine.

I've also occasionally pondered whether partitioning certain tables -
notably the File table - would benefit Bacula.


-- 
  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