On 2015-06-08 03:25 AM, Denis Witt wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Mon, 08 Jun 2015 11:10:11 +0100
> Alan Brown <ajb2 AT mssl.ucl.ac DOT uk> wrote:
>
>> What are you using for spool disk?
>   
>> If it's not fast SSD then you can't run more than a couple of
>> simultaneous backups (you are seek limited with mechanical drives)
> Hi Alan,
>
> I'm using normal (7.200 RPM) HDDs. But, as pointed out in
> my mail, there is only one job running ("despooling Attributes") at the
> moment. All other jobs are still waiting for execution ("waiting on
> max storage jobs").
>
> On the SD there are about no IO-Operations. iotop shows some 100KB
> once in a while. CPU is 100% idle, same on the Director.
>
> The MySQL-Machine writes more or less constant 450KB/sec. to disk
> (mysql process). top shows about 20% wait and 76% idle.
>
> So it shouldn't slow down things that much.
>
> Doesn't it?
>
> Thanks.
>

Can you share your MySQL configuration?

MySQL has a few different disk write modes, some of which are more 
aggressive about laying down small chunks of data one by one while 
others will group things together more making INSERTs in particular 
quite a bit faster.

I wouldn't necessarily finger memory; your IOWAIT time indicates you're 
waiting on disk.  I'm not sure how many CPUs you have in your MySQL box 
or anything like that but it sounds like you've probably got at least 
one core almost totally IO bound.  What's the disk under your MySQL 
database?

Bryn


------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users