Re: Backup taking too long

Martin,

What I suggest you do is take the database offline completely and make a 
manual copy of the database file.  Run the repair tool on the copy of 
the database and see if it detects any problems.

This could be a cache or file fragmentation issue.  You might want to 
try running the online backup procedure on the copy of the database and 
see if the times stay the same, which would rule out a fragmentation 
problem.

Toby.



[email protected] wrote:
> Toby, the database size did not change significantly, the actual size of
> the backup -compressed with TAR- is about 16MB.
> 
> I am concerned, because the backup process jump from 1 minute to 8 minutes
> overnight, after the server restart.
> 
> I wonder if setting a debug-level=20 would shed more light about it, while
> executing the backup.
> 
> I checked the server boot log and did not find relevant ReiserFS messages
> regarding filesystem corruption, the SATA disk seems to be working OK. No
> patches has been applied to this system after the restart. This is a very
> fast disk (Raptor 10000RPM - 54.7MB/sec reported with hdparm -t), and
> online backups take no longer than 1-1.2 minutes before the forced
> restart.
> 
> Should I run the repair tool to see if it does detect something?
> 
> Any help will be appreciated.
> 
> Best regards,
> Martin
> 
> 
> 
>>Did the database change in size since the Linux server was restarted?
>>What size is the database?  Did the configuration of the machine change
>>in any way?  I don't think this is something to be too concerned with
>>because there's many reasons why it may take a little longer.
>>
>>Toby.
>>
>>
>>[email protected] wrote:
>>
>>
>>>Toby:
>>>
>>>I have database with several schemas, regular online backup takes
>>>about 1 minute, sometimes a little more. Three days ago the server
>>>(linux) was restarted without properly shutting down the McKoi
>>>service. After that, the backup takes about 8 minutes!
>>>
>>>I tried restoring a backup to see if backup process comes back to
>>>normal times, but it keeps executing for 8 minutes.
>>>
>>>We have not detected any data loss after the reset -yet-, no problems
>>>reported when starting McKoi with debug-level=30.
>>>
>>>Any ideas?
>>>
>>>Best regards,
>>>Martin
>>
>>
>>
>>---------------------------------------------------------------
>>Mckoi SQL Database mailing list  http://www.mckoi.com/database/
>>To unsubscribe, send a message to [email protected]
> 
> 
> 
> 
> 
> 
> ---------------------------------------------------------------
> Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> To unsubscribe, send a message to [email protected]
> 
> 



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]