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 ph...@caerllewys.net p...@co.ordinate.org Landline: 603.293.8485 ------------------------------------------------------------------------------ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
