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