Re: [Bacula-users] Optimize Mysql

2017-06-01 Thread Petar Kozić
Yes, how to use ? On Jun 1, 2017 2:35 PM, "Josip Deanovic" wrote: > On Thursday 2017-06-01 05:14:14 Petar Kozić wrote: > > Thank you for answer but I wish to stay on MySQL. > > I was alredy tuning mysql, I don’t need that. > > > > I was read somewhere in b

Re: [Bacula-users] Optimize Mysql

2017-06-01 Thread Petar Kozić
Thank you for answer but I wish to stay on MySQL. I was alredy tuning mysql, I don’t need that. I was read somewhere in bacula documentation, that bacula have some script for mysql optimization. My question is for that. Thank you. *—* *Petar Kozić* System Administrator On June 1, 2017 at 11

[Bacula-users] Optimize Mysql

2017-06-01 Thread Petar Kozić
Hi, My bacula servers works now about 2 months with about 3 TB backuped data, on about 10 servers. I see it a little slowed down, and much backup job is in queue. I want to do optimize mysql. What is the safest way to do that ? Thank you in advanced. *—* *Petar Kozić* System Administrator

Re: [Bacula-users] Proper way to calculated space required for backups?

2017-05-25 Thread Petar Kozić
Mr. Michael I think you have problem with space because you use: Maximum Volume Bytes = 30G xMaximum Volumes = 185. =5.5 TB you have 5 TB disk. *—* *Petar Kozić* System Administrator On May 25, 2017 at 2:20:31 PM, Michael Munger (mich...@highpoweredhelp.com) wrote

Re: [Bacula-users] Fatal error sql_create.c

2017-04-15 Thread Petar Kozić
much. *—* *Petar Kozić* System Administrator On April 14, 2017 at 3:33:47 AM, Ana Emília M. Arruda ( emiliaarr...@gmail.com) wrote: Hello Petar, I'm sorry I didn't give you details about the best value for ' innodb_autoinc_lock_mode' to use with bac

Re: [Bacula-users] Fatal error sql_create.c

2017-04-13 Thread Petar Kozić
I using MariaDB 10.1. Which value of innodb_autoinc_lock_mode is best for Bacula, do you know ? *—* *Petar Kozić* System Administrator On April 13, 2017 at 10:04:23 PM, Ana Emília M. Arruda ( emiliaarr...@gmail.com) wrote: Hello Petar, Could you please let us know which Bacula/MySQL

Re: [Bacula-users] Fatal error sql_create.c

2017-04-13 Thread Petar Kozić
Thank you on your answer. Yes I have about 80GB free in drive where is SD working directory. *—* *Petar Kozić* System Administrator On April 13, 2017 at 9:18:39 PM, Ana Emília M. Arruda ( emiliaarr...@gmail.com) wrote: Hi Petar, If you are using spool attributes, you need enough space in

Re: [Bacula-users] Fatal error sql_create.c

2017-04-12 Thread Petar Kozić
Yes, I have. I was upload on pasterbin: http://pastebin.ca/3794414 Log is contionous with same error. *—* *Petar Kozić* System Administrator On April 12, 2017 at 11:03:51 AM, Josip Deanovic (djosip+n...@linuxpages.net) wrote: On Wednesday 2017-04-12 01:07:41 Petar Kozić wrote: > @Jo

Re: [Bacula-users] Fatal error sql_create.c

2017-04-12 Thread Petar Kozić
? *—* *Petar Kozić* System Administrator On April 10, 2017 at 9:06:36 AM, Petar Kozić (petar.ko...@mint.rs) wrote: Are you using spooling? If yes, is your spool directory on the same file system as your database data

Re: [Bacula-users] Fatal error sql_create.c

2017-04-10 Thread Petar Kozić
to 50. Last night I was increase timeout to 150 and set in my.cnf I will inform is the problem solved. Thank you. *—* *Petar Kozić* System Administrator On April 9, 2017 at 7:55:19 PM, Heitor Faria (hei...@bacula.com.br) wrote: > On Sunday 2017-04-09 02:49:41 Petar Kozić wrote: >> H

Re: [Bacula-users] Fatal error sql_create.c

2017-04-09 Thread Petar Kozić
Yes, I am using spooling, but I don't have define spooling directory. Director and mysql is on same server. Storage is on same but on different mount point LVM. On Apr 9, 2017 6:23 PM, "Josip Deanovic" wrote: On Sunday 2017-04-09 05:50:31 Petar Kozić wrote: > This happend o

Re: [Bacula-users] Fatal error sql_create.c

2017-04-09 Thread Petar Kozić
/tmp folder is on root where I have 70 GB free. On Apr 9, 2017 3:18 PM, "Gary R. Schmidt" 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

Re: [Bacula-users] Fatal error sql_create.c

2017-04-09 Thread Petar Kozić
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. Thanks. *—* *Petar Kozić* System Administrator On April 9, 2017 at 12:13:28 PM, Josip Deanovic (djosip+n...@linuxpages.net

[Bacula-users] Fatal error sql_create.c

2017-04-09 Thread Petar Kozić
batch JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name): ERR=Lock wait timeout exceeded; try restarting transaction This error appear only when I doing Full backup at Sunday on my about 10-12 linux instances. *—* *Petar Kozić* System Administrator

Re: [Bacula-users] Restore backup to different client

2017-04-03 Thread Petar Kozić
Yes, thank you for reply. I was already give answer :) I try this and works perfect. Thank again, folks ! ;) *—* *Petar Kozić* System Administrator On April 3, 2017 at 4:55:53 PM, Josip Deanovic (djosip+n...@linuxpages.net) wrote: On Monday 2017-04-03 07:08:02 Petar Kozić wrote: > I have

[Bacula-users] Restore backup to different client

2017-04-03 Thread Petar Kozić
problem. I’d be grateful for an answer, because this means a lot for me. *—* *Petar Kozić* System Administrator -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org!

Re: [Bacula-users] Verify job

2017-03-27 Thread Petar Kozić
I will reply myself :) In documentation have lack. Type is not define, must be Verify Works. Thanks ;) *—* *Petar Kozić* System Administrator On March 27, 2017 at 9:45:37 AM, Petar Kozić (petar.ko...@mint.rs) wrote: Hi folks, I need yours help. I see in documentation New features in

[Bacula-users] Verify job

2017-03-27 Thread Petar Kozić
Level= Can someone explain to me how to use only Data verify ? I need only Data verification without list of new (changes) files. Thank you. *—* *Petar Kozić* System Administrator -- Check out the vibrant tech communi

Re: [Bacula-users] Fwd: Re: Bandwidth in Bacula (slow rate)

2017-03-24 Thread Petar Kozić
. Is there a way to increase speed of verify. >From one client: Files=212,578 Bytes=33,157,419,846 AveBytes/sec=646,709 LastBytes/sec=646,709 Errors=0 >From another client: Files=8,337 Bytes=170,692,703 AveBytes/sec=14,933 LastBytes/sec=28,204 Errors=0 *—* *Petar Kozić* System Adminis

[Bacula-users] Bandwidth in Bacula (slow rate)

2017-03-21 Thread Petar Kozić
width statement in configuration file. How can I run backup faster ? *—* *Petar Kozić* System Administrator -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http:

[Bacula-users] Pools for Full and Incremental

2017-03-20 Thread Petar Kozić
= File1 Pool = ??? Messages = Standard } Thanks. *—* *Petar Kozić* System Administrator -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.

[Bacula-users] How to install latest bacula-client on Centos 6.7 and 7

2017-03-09 Thread Petar Kozić
. *—* *Petar Kozić* -- Announcing the Oxford Dictionaries API! The API offers world-renowned dictionary content that is easy and intuitive to access. Sign up for an account today to start using our lexical data to power