On Apr 9, 2017 3:18 PM, "Gary R. Schmidt" <grs AT mcleod-schmidt.id DOT au> wrote:

On 09/04/2017 22:50, Petar Kozić wrote:
> This happend only on Sunday when Bacula run scheduled full backup on
> about 12 instances. Ofcorse, I have different run time in schedule, but
> because some instances have lot data, in some time 2-3 instances works
> in same time.
>
> I have over 70GB free space on mysql server and thats not problem. I’m
> also increase innodb_timeout from 50 to 100 last week when I have same
> problem.
>
> I have enabled batch insert, maybe thats problem or I must to increase
> inndob_timeout more.
>

How much free *temporary* filespace is there?

MySQL needs lots of /tmp, or however you have configured it.

You might want to run one of the various MySQL tuning tools out there, I
likr http://mysqltuner.pl.

        Cheers,
                Gary    B-)

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users