On 2011-03-02, Eric Bollengier wrote:
> Le mardi 01 mars 2011 14:58:04, Phil Stracchino a écrit :
>> I was looking into what Bacula was doing in the DB this morning, with a
>> MySQL catalog, to see why last night's backup jobs stalled. As a result
>> of my investigations, I have two questions:
>>
Jason A. Kates wrote:
> Alan,
> My file table currently has 434026569 (It grows to over 600Million
> rows)., it is running on a server with 16GB of ram and a decent drive
> array.
Add more ram.
I'm using 48Gb here and was considering adding more before we moved to
Postgres.
Current File tabl
Alan,
My file table currently has 434026569 (It grows to over 600Million
rows)., it is running on a server with 16GB of ram and a decent drive
array. We have dedicated most of the ram in the box to mysql. With
these extra indexes we end up with a lot of IO wait and much slower
backups.
Be
From: "Jason A. Kates"
> The day to day Mysql performance for normal Bacula operation is not
> palatable with the indexes setup on the tables. (IE mysql is so slow
> it's not usable with bacula IMO).
Mysql was "fast enough" for us until we got to ~150 million entries, but
you MUST tune it and
On Wed, Mar 02, 2011 at 02:07:48PM -0500, Jason A. Kates wrote:
> On Wed, 2011-03-02 at 18:29 +0100, Kern Sibbald wrote:
> > On Tuesday 01 March 2011 14:58:04 Phil Stracchino wrote:
> > > I was looking into what Bacula was doing in the DB this morning, with a
> > > MySQL catalog, to see why last ni
Hello,
Le mercredi 02 mars 2011 21:30:17, Phil Stracchino a écrit :
> > You have to know that until mysql 5.1.21 and with a special configuration
> > option that breaks the replication (if used), you can't run two batch
> > insertion process at the same time on innodb.
> >
> > see
> > http://sf.n
On 03/02/11 12:29, Kern Sibbald wrote:
> On Tuesday 01 March 2011 14:58:04 Phil Stracchino wrote:
>> I was looking into what Bacula was doing in the DB this morning, with a
>> MySQL catalog, to see why last night's backup jobs stalled. As a result
>> of my investigations, I have two questions:
>>
On 03/02/11 13:18, Kern Sibbald wrote:
> On Wednesday 02 March 2011 18:57:37 Phil Stracchino wrote:
>> I think I will do some benchmarking with/without batch insert on InnoDB,
>> then, and see if I can determine whether it is actually helping or
>> hurting performance overall if the catalog is on I
On Wednesday 02 March 2011 18:57:37 Phil Stracchino wrote:
> On 03/02/11 12:29, Kern Sibbald wrote:
> > On Tuesday 01 March 2011 14:58:04 Phil Stracchino wrote:
> >> I was looking into what Bacula was doing in the DB this morning, with a
> >> MySQL catalog, to see why last night's backup jobs stall
On 03/02/11 04:43, Eric Bollengier wrote:
> Hello Phil,
>
> Le mardi 01 mars 2011 14:58:04, Phil Stracchino a écrit :
>> I was looking into what Bacula was doing in the DB this morning, with a
>> MySQL catalog, to see why last night's backup jobs stalled. As a result
>> of my investigations, I ha
On Wed, 2011-03-02 at 18:29 +0100, Kern Sibbald wrote:
> On Tuesday 01 March 2011 14:58:04 Phil Stracchino wrote:
> > I was looking into what Bacula was doing in the DB this morning, with a
> > MySQL catalog, to see why last night's backup jobs stalled. As a result
> > of my investigations, I have
Hello Phil,
Le mardi 01 mars 2011 14:58:04, Phil Stracchino a écrit :
> I was looking into what Bacula was doing in the DB this morning, with a
> MySQL catalog, to see why last night's backup jobs stalled. As a result
> of my investigations, I have two questions:
>
> 1.
> If dbcheck finds that e
On Tuesday 01 March 2011 14:58:04 Phil Stracchino wrote:
> I was looking into what Bacula was doing in the DB this morning, with a
> MySQL catalog, to see why last night's backup jobs stalled. As a result
> of my investigations, I have two questions:
>
> 1.
> If dbcheck finds that either of the tw
I was looking into what Bacula was doing in the DB this morning, with a
MySQL catalog, to see why last night's backup jobs stalled. As a result
of my investigations, I have two questions:
1.
If dbcheck finds that either of the two indices it needs are missing,
why does it only offer to create tem
14 matches
Mail list logo
