Re: [Bacula-users] Support for HAVE_POSIX_FADVISE on Bacula Client

Hello, Thanks for pointing this out. I still have problems imagining that they would define O_RDONLY as 0 in a bitmapped variable!!! Unfortunately, the patch below will not work in all cases because O_RDONLY does not correspond to any status in the flags variable. Tomorrow, I will post a fix to

Re: [Bacula-users] 7.2 mysql issue?

Eric, I appreciate all the feedback. We went through a few iterations of tuning awhile back and have not generally had any significant issues over the years with database responsiveness. Back to the original post, it's only been since our upgrade that we started having database lock

Re: [Bacula-users] 7.2 mysql issue?

Hello Stephen, Le 05. 10. 15 19:17, Stephen Thompson a écrit : > > Eric, > > Thanks for the reply. > > I've heard the postgres recommendation a fair number of times. A couple > years back, we setup a parallel instance but even after tuning still > wound up with _worse_ performance than with

Re: [Bacula-users] 7.2 mysql issue?

Thanks Ana! Something such as SELECT ClientId, SUM(JobFiles) AS NB FROM Job GROUP BY ClientId ORDER BY NB DESC; should also do the trick a bit more faster ;-) Best Regards, Eric Le 07. 10. 15 15:23, Ana Emília M. Arruda a écrit : > Hello Stephen, > > On Mon, Oct 5, 2015 at 2:17 PM, Stephen

Re: [Bacula-users] FreeBSD 10.2 & Bacula 7.2 compile errors

> On Oct 9, 2015, at 6:01 PM, Francisco Javier Funes Nieto > wrote: > > Great news !! > > To me and to my buggy debian 8 server. > > Thanks!! You are welcome. I upgraded my server today. Remember to run the database upgrade script. > >

Re: [Bacula-users] FreeBSD 10.2 & Bacula 7.2 compile errors

Great news !! To me and to my buggy debian 8 server. Thanks!! El viernes, 9 de octubre de 2015, Dan Langille escribió: > > On Oct 9, 2015, at 1:19 PM, Dan Langille > wrote: > > > On Oct 1, 2015, at 9:26

Re: [Bacula-users] 7.2 mysql issue?

mysql> SELECT ClientId, SUM(JobFiles) AS NB FROM Job WHERE PurgedFiles=0 GROUP BY ClientId ORDER BY NB DESC; +--++ | ClientId | NB | +--++ | 10 | 2239841562 | | 68 | 636728984 | | 157 | 291057196 | | 198 | 138969710 | |

Re: [Bacula-users] 7.2 mysql issue?

Hello Eric! Thank you. I thought that you were looking for the number of filename per Client that had not been pruned yet :). Best regards, Ana On Fri, Oct 9, 2015 at 3:17 AM, Eric Bollengier < eric.bolleng...@baculasystems.com> wrote: > Thanks Ana! > > Something such as > > SELECT ClientId,

Re: [Bacula-users] [Bacula-devel] FreeBSD 10.2 & Bacula 7.2 compile errors

> On Oct 1, 2015, at 9:26 AM, Kern Sibbald wrote: > > Hello Dan, > > That is good news ... thanks. > > Best regards, > Kern > > On 15-10-01 05:10 AM, Dan Langille wrote: >>> On Sep 21, 2015, at 10:16 PM, Dan Langille >>>

Re: [Bacula-users] 7.2 mysql issue?

Very good point Ana, So, you might want to add to the query "AND PurgedFiles = 0" Thanks, Eric Le 09. 10. 15 14:24, Ana Emília M. Arruda a écrit : > Hello Eric! > > Thank you. I thought that you were looking for the number of filename > per Client that had not been pruned yet :). > > Best

Re: [Bacula-users] [Bacula-devel] FreeBSD 10.2 & Bacula 7.2 compile errors

> On Oct 9, 2015, at 1:19 PM, Dan Langille wrote: > > >> On Oct 1, 2015, at 9:26 AM, Kern Sibbald > > wrote: >> >> Hello Dan, >> >> That is good news ... thanks. >> >> Best regards, >> Kern >> >> On 15-10-01 05:10 AM, Dan