dbTalk Databases Forums  

Re: How quickly do you DUMP?

comp.databases.sybase comp.databases.sybase


Discuss Re: How quickly do you DUMP? in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
PDreyer
 
Posts: n/a

Default Re: How quickly do you DUMP? - 11-21-2008 , 04:33 AM








Mikhail Teterin wrote:
Quote:
Hello!

I'm trying to improve the speed of the dumps and seem to be limited not by
my storage media or network speed, but by the writing speed of the backup
server (the source).

Indeed, when I use my libpipe-plugin (see sig) to dump a 55Gb database:

�dump�databse�foo�to�'pipe::cat�>�/dev/null'

I only get the throughput of less than 30Mb/s (single stripe)... This is on
SunFire v490...

If I go up to two stripes:

�dump�databse�foo�to�'pipe::cat�>�/dev/null'�\
��stripe�on�'pipe::cat�>��/dev/null'

it is about the same...

So, what's YOUR best backup throughput -- onto your fastest storage? Thanks!
Yours,

-mi

--
http://libpipe.com�-�ease�your�Sybase�backups

I see faster speeds.
How long does it take you to copy a large file (MB/s)?

e.g. Sun Fire E6900 & SUN-StorEdge3510
dump 100GB to 8 stripes

Time KBdumped Kbyte/sec
11:32:37 962384
11:32:43 1891634 154875
11:32:49 2820390 154793
11:32:55 3749644 154876
11:33:00 4675846 185240
11:33:06 5604078 154705
11:33:14 6570500 120803
11:33:19 7499748 185850
11:33:25 8428494 154791
11:33:31 9354184 154282
11:33:38 10283436 132750
11:33:43 11212684 185850
11:33:49 12141936 154875
11:33:56 13110638 138386
11:34:02 14019224 151431
11:34:08 14971076 158642
11:34:13 15879662 181717
11:34:19 16831514 158642
11:34:26 17740100 129798
11:34:31 18691952 190370
11:34:37 19643804 158642
11:34:44 20552390 129798
11:34:48 21504242 237963
11:34:55 22412828 129798
11:35:01 23364680 158642
11:35:06 24273266 181717
11:35:12 25225118 158642
11:35:19 26176970 135979
11:35:25 27085556 151431
11:35:30 28037408 190370
11:35:36 28945994 151431
11:35:44 29897846 118982
11:35:49 30806432 181717
....


Reply With Quote
  #2  
Old   
PDreyer
 
Posts: n/a

Default Re: How quickly do you DUMP? - 11-21-2008 , 04:33 AM








Mikhail Teterin wrote:
Quote:
Hello!

I'm trying to improve the speed of the dumps and seem to be limited not by
my storage media or network speed, but by the writing speed of the backup
server (the source).

Indeed, when I use my libpipe-plugin (see sig) to dump a 55Gb database:

�dump�databse�foo�to�'pipe::cat�>�/dev/null'

I only get the throughput of less than 30Mb/s (single stripe)... This is on
SunFire v490...

If I go up to two stripes:

�dump�databse�foo�to�'pipe::cat�>�/dev/null'�\
��stripe�on�'pipe::cat�>��/dev/null'

it is about the same...

So, what's YOUR best backup throughput -- onto your fastest storage? Thanks!
Yours,

-mi

--
http://libpipe.com�-�ease�your�Sybase�backups

I see faster speeds.
How long does it take you to copy a large file (MB/s)?

e.g. Sun Fire E6900 & SUN-StorEdge3510
dump 100GB to 8 stripes

Time KBdumped Kbyte/sec
11:32:37 962384
11:32:43 1891634 154875
11:32:49 2820390 154793
11:32:55 3749644 154876
11:33:00 4675846 185240
11:33:06 5604078 154705
11:33:14 6570500 120803
11:33:19 7499748 185850
11:33:25 8428494 154791
11:33:31 9354184 154282
11:33:38 10283436 132750
11:33:43 11212684 185850
11:33:49 12141936 154875
11:33:56 13110638 138386
11:34:02 14019224 151431
11:34:08 14971076 158642
11:34:13 15879662 181717
11:34:19 16831514 158642
11:34:26 17740100 129798
11:34:31 18691952 190370
11:34:37 19643804 158642
11:34:44 20552390 129798
11:34:48 21504242 237963
11:34:55 22412828 129798
11:35:01 23364680 158642
11:35:06 24273266 181717
11:35:12 25225118 158642
11:35:19 26176970 135979
11:35:25 27085556 151431
11:35:30 28037408 190370
11:35:36 28945994 151431
11:35:44 29897846 118982
11:35:49 30806432 181717
....


Reply With Quote
  #3  
Old   
PDreyer
 
Posts: n/a

Default Re: How quickly do you DUMP? - 11-21-2008 , 04:33 AM





Mikhail Teterin wrote:
Quote:
Hello!

I'm trying to improve the speed of the dumps and seem to be limited not by
my storage media or network speed, but by the writing speed of the backup
server (the source).

Indeed, when I use my libpipe-plugin (see sig) to dump a 55Gb database:

�dump�databse�foo�to�'pipe::cat�>�/dev/null'

I only get the throughput of less than 30Mb/s (single stripe)... This is on
SunFire v490...

If I go up to two stripes:

�dump�databse�foo�to�'pipe::cat�>�/dev/null'�\
��stripe�on�'pipe::cat�>��/dev/null'

it is about the same...

So, what's YOUR best backup throughput -- onto your fastest storage? Thanks!
Yours,

-mi

--
http://libpipe.com�-�ease�your�Sybase�backups

I see faster speeds.
How long does it take you to copy a large file (MB/s)?

e.g. Sun Fire E6900 & SUN-StorEdge3510
dump 100GB to 8 stripes

Time KBdumped Kbyte/sec
11:32:37 962384
11:32:43 1891634 154875
11:32:49 2820390 154793
11:32:55 3749644 154876
11:33:00 4675846 185240
11:33:06 5604078 154705
11:33:14 6570500 120803
11:33:19 7499748 185850
11:33:25 8428494 154791
11:33:31 9354184 154282
11:33:38 10283436 132750
11:33:43 11212684 185850
11:33:49 12141936 154875
11:33:56 13110638 138386
11:34:02 14019224 151431
11:34:08 14971076 158642
11:34:13 15879662 181717
11:34:19 16831514 158642
11:34:26 17740100 129798
11:34:31 18691952 190370
11:34:37 19643804 158642
11:34:44 20552390 129798
11:34:48 21504242 237963
11:34:55 22412828 129798
11:35:01 23364680 158642
11:35:06 24273266 181717
11:35:12 25225118 158642
11:35:19 26176970 135979
11:35:25 27085556 151431
11:35:30 28037408 190370
11:35:36 28945994 151431
11:35:44 29897846 118982
11:35:49 30806432 181717
....


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.