Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience

2010-04-20 Thread Koldo Santisteban
14:10 To: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience On Tue, Apr 13, 2010 at 02:03:39PM +0100, Graham Keeling wrote: On Tue, Apr 13, 2010 at 02:42:15PM +0200, Koldo Santisteban wrote: Hello I am working

Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience

2010-04-20 Thread JanJaap Scholing
| |+---++--+--+-+---+-+--++--++-+ Are these the right ones? Thanks, Jan Jaap Date: Tue, 20 Apr 2010 14:53:54 +0200 From: ksantiste...@gmail.com To: evan.fra...@rms.com CC: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] bacula 5.0.1 and db issues - please,share your experience Creating indexes solve performance issues

Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience

2010-04-16 Thread Evan Fraser
Thanks for this, it fixed my problem. Cheers, Evan. -Original Message- From: Graham Keeling [mailto:gra...@equiinet.com] Sent: 13 April 2010 14:10 To: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience On Tue, Apr

Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience

2010-04-14 Thread Koldo Santisteban
Thanks for your answers. Stephen, do you use bconsole or bat? Perhaps the issue is only on bat. I recognize that i only use bweb and bat (on windows). Regarding your comments Stephen, my bacula server is smaller than yours, but my catalog size was 400 Mb (Baculas is working since 2 months ago). I

Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience

2010-04-14 Thread Matija Nalis
On Wed, Apr 14, 2010 at 03:29:29PM +0200, Koldo Santisteban wrote: Thanks for your answers. Stephen, do you use bconsole or bat? Perhaps the issue is only on bat. I recognize that i only use bweb and bat (on windows). For what it's worth, I used bconsole, and it was extremly slow (20+ hours)

Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience

2010-04-14 Thread Stephen Thompson
I mostly use bat for restores (i.e. building restore tree). I did nothing with my tables regarding indexing. I have whatever the bacula scripts create by defaults. In regards to tuning, I did play with changing the join and sort buffer sizes. I found a 'slight' increase in performance. By

Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience

2010-04-14 Thread Koldo Santisteban
Stephen, do you use bat or bconsole? Perhaps the issue os on bat console... El 13 de abr de 2010, 7:37 p.m., Thomas Mueller tho...@chaschperli.ch escribió: Am Tue, 13 Apr 2010 15:59:25 +0200 schrieb Koldo Santisteban: thanks for your answer. The first stage was with mysql 5.0.77, and works

Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience

2010-04-14 Thread ebollengier
Hello Stephan, Thanks for your feeback, sometime, few users have performance problem due to bad settings and can give bad advise or the impression that nothing can be done whereas it works well on ten of thousand of silent users. In this case the performance problem is due to the presence of

[Bacula-users] bacula 5.0.1 and db issues - please, share your experience

2010-04-13 Thread Koldo Santisteban
Hello I am working with bacula 5.0.1. On first stage i setup the server with bacula 5.0.1 and Mysql, but, when i need to restore i have found that the bulid tree process take 10-12 hours (or more). I have read all about this issues and i can see that no exists any magic solution. In order to solve

Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience

2010-04-13 Thread Graham Keeling
On Tue, Apr 13, 2010 at 02:42:15PM +0200, Koldo Santisteban wrote: Hello I am working with bacula 5.0.1. On first stage i setup the server with bacula 5.0.1 and Mysql, but, when i need to restore i have found that the bulid tree process take 10-12 hours (or more). I have read all about this

Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience

2010-04-13 Thread Graham Keeling
On Tue, Apr 13, 2010 at 02:03:39PM +0100, Graham Keeling wrote: On Tue, Apr 13, 2010 at 02:42:15PM +0200, Koldo Santisteban wrote: Hello I am working with bacula 5.0.1. On first stage i setup the server with bacula 5.0.1 and Mysql, but, when i need to restore i have found that the bulid

Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience

2010-04-13 Thread Matija Nalis
On Tue, Apr 13, 2010 at 02:42:15PM +0200, Koldo Santisteban wrote: Hello I am working with bacula 5.0.1. On first stage i setup the server with bacula 5.0.1 and Mysql, but, when i need to restore i have found that the bulid tree process take 10-12 hours (or more). I have read all about this

Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience

2010-04-13 Thread John Drescher
I am working with bacula 5.0.1. On first stage i setup the server with bacula 5.0.1 and Mysql, but, when i need to restore i have found that the bulid tree process take 10-12 hours (or more). I have read all about this issues and i can see that no exists any magic solution. In order to solve

Re: [Bacula-users] bacula 5.0.1 and db issues - please, share your experience

2010-04-13 Thread Koldo Santisteban
thanks for your answer. The first stage was with mysql 5.0.77, and works with bacula 3.0.3 without problems. I have used the same database and server with bacula 5.0.1. The bacula server + DB is a 3,5 Gb Ram with a Xeon processor. I have tested my environment installing postgree on the same