Bacula-users

Re: [Bacula-users] Bacula Catalog Server - MySQL - 1 Core Used Max ?

2015-03-24 13:03:34
Subject: Re: [Bacula-users] Bacula Catalog Server - MySQL - 1 Core Used Max ?
From: John Drescher <drescherjm AT gmail DOT com>
To: Robert Heinzmann <r.heinzmann AT freelancer.traviangames DOT com>
Date: Tue, 24 Mar 2015 13:01:36 -0400
> One more question for clarification:
>
> Attribute spooling only solves "insert and update issues" and not select 
> issues right ?
>
Correct.

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

I would expect very few selects during a backup and very many inserts.
Every single file that is backed up should be an insert. With
attribute spooling this changes into a batch insert after the job has
finished.

John

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