Subject | Re[2]: [firebird-support] gbak speed |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2013-04-11T09:34:46Z |
Hello, Nick!
Thursday, April 11, 2013, 1:31:17 PM, you wrote:
NU> the database & backup are already seperate devices
were you thinking to add -g option to gbak command line?
NU> On 11 April 2013 10:25, Marcus Bajohr <marcus.bajohr@...> wrote:
Dmitry Kuzmenko, www.ib-aid.com
Thursday, April 11, 2013, 1:31:17 PM, you wrote:
NU> the database & backup are already seperate devices
were you thinking to add -g option to gbak command line?
NU> On 11 April 2013 10:25, Marcus Bajohr <marcus.bajohr@...> wrote:
>> **--
>>
>>
>> Hej,
>>
>> from my little knowledge i have: are the db and the backup on different
>> devices? Or are they both on the raid?
>> I've reduced the backup time from 1,5 mours to 40 minutes for a ~55 GB
>> db by simply writing the backup to another physical dev
>>
>> cheers, Marcus
>>
>> > Nick Upson <mailto:nu@...>
>> > Donnerstag, 11. April 2013 11:19
>>
>> > Hi,
>> >
>> > I'm need to speedup my database backup, its currently taking 6 hours to
>> > backup a 74Gb database. Using firebird 2.1.5 on centos, database is on
>> > fast
>> > drives with raid 10.
>> >
>> > How does this compare with the experience of others?
>> >
>> > the command line used is: (and I do need the garbage collect)
>> >
>> > gbak -user sysdba -pass XXX -backup localhost:/opt/db/mydb.fdb stdout >
>> > /var/archive/db/mydb.fbk
>> >
>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
Dmitry Kuzmenko, www.ib-aid.com