Re: [Bacula-users] (no subject)
2015-09-25 14:40:15
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
|
|
|