IMHO I know that there are several MySQL tunings that can be made, but one that
I tested that really improves the writing times in a factor of more than 1000
is the enabling of synchronous mode transactions:
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DIRECT
Regards,
==============================================================================
Heitor Medrado de Faria - LPIC-III | ITIL-F
01 a 13 de Abril - Novo Treinamento Telepresencial Bacula:
http://www.bacula.com.br/?p=2174
61 8268-4220
Site: www.bacula.com.br | Facebook: heitor.faria | Gtalk: heitorfaria AT gmail
DOT com
===============================================================================
----- Mensagem original -----
> De: "Josh Fisher" <jfisher AT pvct DOT com>
> Para: bacula-users AT lists.sourceforge DOT net
> Enviadas: Terça-feira, 24 de março de 2015 14:16:06
> Assunto: Re: [Bacula-users] Bacula Catalog Server - MySQL - 1 Core Used Max ?
>
>
>
> On 3/24/2015 12:57 PM, Robert Heinzmann wrote:
> > One more question for clarification:
> >
> > Attribute spooling only solves "insert and update issues" and not select
> > issues right ?
> >
> > Our monitoring shows that we only have 10 -20 inserts/s for the DB but the
> > selects are capped at ~370 selects/second during peak times.
>
> Look into enabling innodb_file_per_table setting. InnoDB uses 4 threads
> as i/o threads in addition to the connection manager thread and one
> thread per connection. Each table in a separate file means that indices
> on those tables are also separated and may allow for more parallel i/o.
> But still, attribute spooling is needed to optimize DB transactions.
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for
> all
> things parallel software development, from weekly thought leadership blogs to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
