Hi Phil, I apologize for such a tardy reply.
Yes, we are using InnoDB. As far as I know we are configured correctly. However, what do you recommend are the most important configuration items to look at? Thank you for the help! -craig On Tue, Sep 15, 2015 at 4:19 AM, Phil Stracchino <[email protected]> wrote: > 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 > [email protected] > [email protected] > Landline: 603.293.8485 > > > ------------------------------------------------------------------------------ > _______________________________________________ > Bacula-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/bacula-users >
------------------------------------------------------------------------------
_______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
