Re: Backup taking too long

<[email protected]>
Newsgroups gmane.comp.db.mckoi
Message-ID <[email protected]>
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]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.