Today I removed all the additional indexes from the table File (in my
production bacula server).
And re-indexes, which are specified in src/cats/make_mysql_tables.in
I would like once again to check how the dbcheck worked.
This will take some time.
The results, I will announce later.
I still want
Yuri Timofeev wrote:
> 2008/9/5 Kern Sibbald <[EMAIL PROTECTED]>:
>
>>From what I understand, it *does* work, but just slowly. It is not correct to
>>say that nothing is done. It has been working and doing its job it may have
>>even been removing orphaned records in this time.
>
> No. This is
On Friday 05 September 2008 20:32:32 Yuri Timofeev wrote:
> 2008/9/5 Kern Sibbald <[EMAIL PROTECTED]>:
> >From what I understand, it *does* work, but just slowly. It is not correct
> > to say that nothing is done. It has been working and doing its job it
> > may have even been removing orphaned re
2008/9/5 Kern Sibbald <[EMAIL PROTECTED]>:
>From what I understand, it *does* work, but just slowly. It is not correct to
>say that nothing is done. It has been working and doing its job it may have
>even been removing orphaned records in this time.
No. This is not a work.
Mysql all the time
Hello,
On Thursday 04 September 2008 20:24:29 Yuri Timofeev wrote:
> Hi
>
> Some time ago I received a problem - dbcheck does not work with options:
From what I understand, it *does* work, but just slowly.
>
> 8) Check for orphaned File records
> 9) Check for orphaned Path records
>
> dbcheck wo
Hi
Some time ago I received a problem - dbcheck does not work with options:
8) Check for orphaned File records
9) Check for orphaned Path records
dbcheck worked 3 days and nothing is done. I stopped dbcheck (ctrl+c)
and restart MySQL.
I explain what I need dbcheck:
If you do not have enough sp
On Wednesday 03 September 2008 08:22:31 Yuri Timofeev wrote:
> Hi
>
> 2008/8/31 Eric Bollengier <[EMAIL PROTECTED]>:
> > If you want to use new indexes with dbcheck, you can modify dbcheck.c in
> > this way :
> > - ask to the user if he wants to add them (think about disk space)
> > - add them +
On Wednesday 03 September 2008 08:22:31 Yuri Timofeev wrote:
> Hi
>
> 2008/8/31 Eric Bollengier <[EMAIL PROTECTED]>:
> > If you want to use new indexes with dbcheck, you can modify dbcheck.c in
> > this way :
> > - ask to the user if he wants to add them (think about disk space)
> > - add them +
Hi
2008/8/31 Eric Bollengier <[EMAIL PROTECTED]>:
>
> If you want to use new indexes with dbcheck, you can modify dbcheck.c in this
> way :
> - ask to the user if he wants to add them (think about disk space)
> - add them + run analyse
> - run the cleanup operation
> - remove them
>
> FYI, pos
Marc Cousin wrote:
> On Monday 01 September 2008 02:38:30 Dan Langille wrote:
>> Eric Bollengier wrote:
>>> Hello Yuri,
>>>
>>> Adding indexes will probably speed up dbcheck, but it will slow down the
>>> attribute insertion process and grow up the database.
>> Do we have statistics on the performa
Yuri Timofeev wrote:
> Hi
>
> 2008/9/1 Dan Langille <[EMAIL PROTECTED]>:
>> If the index problem is just MySQL related, perhaps we should be
>> including these indexes with PostgreSQL. FWIW, I seem to have these
>> indexes already:
>>
>> bacula=# \d file
>> Table "pub
Hi
2008/8/31 Yuri Timofeev <[EMAIL PROTECTED]>:
> I believe that the results of this discussion concerns "[Bacula-users] Bacula
> 2.2.8, dbcheck never completes"
> requires a small patch, see attached file.
I did additional tests.
To work dbcheck need only one additional index:
CREATE INDEX idx
On Monday 01 September 2008 11:30:58 Marc Cousin wrote:
> On Monday 01 September 2008 08:51:48 Kern Sibbald wrote:
> > Hello,
> >
> > Thanks for the patch. I see no problem applying it as it is a comment,
> > which is a suggestion. However, as Eric has said, it may not be such a
> > good idea for
On Monday 01 September 2008 02:38:30 Dan Langille wrote:
> Eric Bollengier wrote:
> > Hello Yuri,
> >
> > Adding indexes will probably speed up dbcheck, but it will slow down the
> > attribute insertion process and grow up the database.
>
> Do we have statistics on the performance slowdown?
I don'
On Monday 01 September 2008 08:51:48 Kern Sibbald wrote:
> Hello,
>
> Thanks for the patch. I see no problem applying it as it is a comment,
> which is a suggestion. However, as Eric has said, it may not be such a
> good idea for users to turn these indexes on since, as he points out, they
> will
Hi
>>
>> Million files in a single Jobs? Maybe this is indeed a rare case.
>
> No, it is, unfortunately, not at all rare. There are even some users with 10
> Million files in a single backup. This causes a number of problems for
> restore. We have some ideas on how to fix it but not the time ..
Hello,
Thanks for the patch. I see no problem applying it as it is a comment, which
is a suggestion. However, as Eric has said, it may not be such a good idea
for users to turn these indexes on since, as he points out, they will
probably leave them.
I like Eric's suggestion that dbcheck auto
On Sunday 31 August 2008 23:17:05 Yuri Timofeev wrote:
> 2008/8/31 Eric Bollengier <[EMAIL PROTECTED]>:
> > Le Sunday 31 August 2008 21:32:16 Yuri Timofeev, vous avez écrit :
> >> Hi
> >>
> >> 2008/8/31 Eric Bollengier <[EMAIL PROTECTED]>:
> >> > Adding indexes will probably speed up dbcheck, but i
Eric Bollengier wrote:
> Hello Yuri,
>
> Adding indexes will probably speed up dbcheck, but it will slow down the
> attribute insertion process and grow up the database.
Do we have statistics on the performance slowdown?
Seriously, not adding Foreign Keys or indexes because they slow things
do
2008/8/31 Eric Bollengier <[EMAIL PROTECTED]>:
> Le Sunday 31 August 2008 21:32:16 Yuri Timofeev, vous avez écrit :
>> Hi
>>
>> 2008/8/31 Eric Bollengier <[EMAIL PROTECTED]>:
>> > Adding indexes will probably speed up dbcheck, but it will slow down the
>> > attribute insertion process and grow up t
Le Sunday 31 August 2008 21:32:16 Yuri Timofeev, vous avez écrit :
> Hi
>
> 2008/8/31 Eric Bollengier <[EMAIL PROTECTED]>:
> > Adding indexes will probably speed up dbcheck, but it will slow down the
> > attribute insertion process and grow up the database.
>
> I wrote earlier (see reference to the
Hi
2008/8/31 Eric Bollengier <[EMAIL PROTECTED]>:
>
> Adding indexes will probably speed up dbcheck, but it will slow down the
> attribute insertion process and grow up the database.
I wrote earlier (see reference to the discussion), that dbcheck can't
complete the job for 3 days!
Once the necess
Hello Yuri,
Adding indexes will probably speed up dbcheck, but it will slow down the
attribute insertion process and grow up the database.
The dbcheck operation have to be run once per month, maybe twice per year.
So, we can say that speed of attribute insertion is much more important than
dbch
Hi,
I believe that the results of this discussion concerns
"[Bacula-users] Bacula 2.2.8, dbcheck never completes"
http://sourceforge.net/mailarchive/forum.php?thread_name=48A984BF.4050206%40umdnj.edu&forum_name=bacula-users
requires a small patch, see attached file.
Since all fields (which fall
24 matches
Mail list logo
