Re: [Bacula-users] Bacula backup speed

2015-12-15 Thread Gary R. Schmidt
Hi Dave, On 2015-12-16 12:39, Lewis, Dave wrote: >> -Original Message- >> From: Alan Brown [mailto:a...@mssl.ucl.ac.uk] >> Sent: Tuesday, December 15, 2015 8:08 AM >> To: Lewis, Dave; bacula-users@lists.sourceforge.net >> Subject: Re: [Bacula-users] Bacula backup speed > ... >> What size i

Re: [Bacula-users] Bacula backup speed

2015-12-15 Thread Lewis, Dave
> -Original Message- > From: Heitor Faria [mailto:hei...@bacula.com.br] > Sent: Tuesday, December 15, 2015 8:21 AM > To: Alan Brown > Cc: Lewis, Dave; bacula-users@lists.sourceforge.net > Subject: Re: [Bacula-users] Bacula backup speed > ... > > Suggestion: http://bacula.us/tuning/ Thanks,

Re: [Bacula-users] Bacula backup speed

2015-12-15 Thread Lewis, Dave
> -Original Message- > From: Alan Brown [mailto:a...@mssl.ucl.ac.uk] > Sent: Tuesday, December 15, 2015 8:08 AM > To: Lewis, Dave; bacula-users@lists.sourceforge.net > Subject: Re: [Bacula-users] Bacula backup speed ... > What size is your database? ("select count(*) from File;") What write

Re: [Bacula-users] Bacula backup speed

2015-12-15 Thread Bryn Hughes
On 2015-12-15 04:50 PM, Lewis, Dave wrote: >> -Original Message- >> From: Uwe Schuerkamp [mailto:uwe.schuerk...@nionex.net] >> Sent: Tuesday, December 15, 2015 4:47 AM >> To: Lewis, Dave >> Cc: bacula-users@lists.sourceforge.net >> Subject: Re: [Bacula-users] Bacula backup speed >> > ... >>

Re: [Bacula-users] Bacula backup speed

2015-12-15 Thread Lewis, Dave
> From: Josh Fisher [mailto:jfis...@pvct.com] > Sent: Tuesday, December 15, 2015 6:57 AM > To: bacula-users@lists.sourceforge.net > Subject: Re: [Bacula-users] Bacula backup speed > ... > > What else is writing to this same disk when the metadata is being > written? Probably not much. The database

Re: [Bacula-users] Bacula backup speed

2015-12-15 Thread Lewis, Dave
> -Original Message- > From: Uwe Schuerkamp [mailto:uwe.schuerk...@nionex.net] > Sent: Tuesday, December 15, 2015 4:47 AM > To: Lewis, Dave > Cc: bacula-users@lists.sourceforge.net > Subject: Re: [Bacula-users] Bacula backup speed > ... > Hi Dave, > > how large is your catalog database? How

Re: [Bacula-users] Bacula backup speed

2015-12-15 Thread Alan Brown
On 15/12/15 13:20, Heitor Faria wrote: > Suggestion: http://bacula.us/tuning/ Whilst that page is a good starting point, a couple of points are flat out wrong: EG: setting maximum block size in tapes - DON'T SET THIS - EVER (unless the driver manufacturer advises it) Compression should only _

[Bacula-users] TIP: Create function and alias to use bconsole from shell

2015-12-15 Thread Winnux
Thanks for the tips to further improve this guys! The end result is a command you can easily pipe into less and search for the job or volume you're after. It's far better than trying to sort it out inside bconsole when thousands of jobs or volumes scroll off screen. +---

Re: [Bacula-users] Bacula backup speed

2015-12-15 Thread Heitor Faria
>> We are running MySQL, and the database is on the same server as the director. >> The disk that the database is on is a 7200 RPM, 3 Gb/s SATA disk. > > What size is your database? ("select count(*) from File;") > What write speeds are you actually achieving to the database drive? > (MB/s and io

Re: [Bacula-users] Bacula backup speed

2015-12-15 Thread Alan Brown
On 14/12/15 22:19, Lewis, Dave wrote: > We are running MySQL, and the database is on the same server as the director. > The disk that the database is on is a 7200 RPM, 3 Gb/s SATA disk. What size is your database? ("select count(*) from File;") What write speeds are you actually achieving to the

Re: [Bacula-users] Bacula backup speed

2015-12-15 Thread Josh Fisher
On 12/14/2015 5:19 PM, Lewis, Dave wrote: > We are running MySQL, and the database is on the same server as the director. > The disk that the database is on is a 7200 RPM, 3 Gb/s SATA disk. What else is writing to this same disk when the metadata is being written? > > Thanks, > Dave > > >

Re: [Bacula-users] Bacula backup speed

2015-12-15 Thread Uwe Schuerkamp
On Mon, Dec 14, 2015 at 09:12:06PM +, Lewis, Dave wrote: > Hi, > > Thanks. I ran it again with attribute spooling. That sped up the backup of > data to the disk pool - instead of 6 hours it took less than 2 - but writing > the file metadata afterwards took nearly 6 hours. > > 12-Dec 18:24 j