How to safely sweep IB 6.0?

Thread View: borland.public.interbase.linux

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Jason Mon, 20 Nov 2000 00:00

#29

Author: Jason
Date: Mon, 20 Nov 2000 00:00

11 lines
828 bytes

I have heard that sweeping interbase could corrupt data.

What is the recommended way of compressing IB 6.0 SuperServer on Linux?

Our server has been running fine since July completely unattended - which is
a good thing.  Is there anything else that I
can do to make sure that things continue to go smoothly?



Thanks.

Re: How to safely sweep IB 6.0?

#32

Author: Jeff Overcash (TeamB)
Date: Mon, 20 Nov 2000 00:00

28 lines
1479 bytes

Jason wrote:
> 
> I have heard that sweeping interbase could corrupt data.
> 

This was a 5.5 bug and fixed in 5.6 IIRC.  I have not heard of problems with
sweeping in 6.0.

> What is the recommended way of compressing IB 6.0 SuperServer on Linux?
> 

Pnly way is to backup and restore if you want to reclaim empty space.  Be aware
that IB will grow back out to about 20% empty space fairly quickly as it
performs better not fully compressed.

> Our server has been running fine since July completely unattended - which is
> a good thing.  Is there anything else that I
> can do to make sure that things continue to go smoothly?
> 
> Thanks.

-- 
Jeff Overcash (TeamB)   | Talk about failure
(Please do not email    | To fall is not to fail
 me directly unless     | Failure isn't about falling down
 asked.  Thank You)     | Failure is staying down (Marillion)

Re: How to safely sweep IB 6.0?

#37

Author: Jason
Date: Thu, 23 Nov 2000 00:00

37 lines
1652 bytes

Thanks Jeff.

Your always helpful.

Jeff Overcash (TeamB) <overcash@onramp.net> wrote in message
news:3A19CB0C.6856E933@onramp.net...
>
>
> Jason wrote:
> >
> > I have heard that sweeping interbase could corrupt data.
> >
>
> This was a 5.5 bug and fixed in 5.6 IIRC.  I have not heard of problems
with
> sweeping in 6.0.
>
> > What is the recommended way of compressing IB 6.0 SuperServer on Linux?
> >
>
> Pnly way is to backup and restore if you want to reclaim empty space.  Be
aware
> that IB will grow back out to about 20% empty space fairly quickly as it
> performs better not fully compressed.
>
> > Our server has been running fine since July completely unattended -
which is
> > a good thing.  Is there anything else that I
> > can do to make sure that things continue to go smoothly?
> >
> > Thanks.
>
> --
> Jeff Overcash (TeamB)   | Talk about failure
> (Please do not email    | To fall is not to fail
>  me directly unless     | Failure isn't about falling down
>  asked.  Thank You)     | Failure is staying down (Marillion)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads