On 09/25/15 14:00, Craig Shiroma wrote: > 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?
Principal items I would check: - Make sure innodb_buffer_pool_size is adequate - Make sure innodb_buffer-pool_instances is set appropriately - Make sure innodb_io_capacity is set appropriately for your storage device(s) - Set innodb_autoinc_lock_mode = 2 - Set innodb_flush_log_at_trx_commit = 2 - Set innodb_stats_on_metadata = 0 - innodb_log_file_size should be set to at least 50M -- 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
