Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How quickly do you DUMP?

 
   Database Help (Home) -> Sybase RSS
Next:  Help working on Large Database  
Author Message
Mikhail Teterin

External


Since: Dec 26, 2007
Posts: 5



(Msg. 1) Posted: Thu Nov 20, 2008 6:54 pm
Post subject: How quickly do you DUMP?
Archived from groups: comp>databases>sybase (more info?)

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

 >> Stay informed about: How quickly do you DUMP? 
Back to top
Login to vote
PDreyer

External


Since: Nov 19, 2007
Posts: 7



(Msg. 2) Posted: Fri Nov 21, 2008 2:33 am
Post subject: Re: How quickly do you DUMP? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Mikhail Teterin wrote:
> 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
....

 >> Stay informed about: How quickly do you DUMP? 
Back to top
Login to vote
Mikhail Teterin

External


Since: Dec 26, 2007
Posts: 5



(Msg. 3) Posted: Fri Nov 21, 2008 5:06 pm
Post subject: Re: How quickly do you DUMP? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

PDreyer wrote:

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

Well, indeed, dumping the same database from a v890 is over 4 times
faster... Probably, this is because the DB on the v890 is online (and in
memory), whereas the one I was experimenting with before is an offline
replica, used on for "logshipping"...

-mi
 >> Stay informed about: How quickly do you DUMP? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Reloading a 12.5 Dump into Sybase 15 causes failures on sp.. -

Problem with ASE 12.5 Backup Server - Hello everyone !!! My problem: I have recently installed ASE 12.5 on winxp. When I try to make a dump or load with isql or DBArtisan i get this message: "Can't open a connection to site 'SYB_BACKUP'. See the error log file in the SQL Server boot..

Tuning stored procedures - Hi Everyone; We are working on tuning a compact framework mobile application which uses the Sybase iAnywhere 9.0 as the database. Performance of the stored procedures have been really bad. But we are at our wits end trying to find out the Stored..

PERL DBI Sybase::DBD error --- Dynaloader.pm - Sybase.so - All - I hesitated to post this as I saw many similar postings in my trawlings. However I have been unable to determine the problem in relation to the answers I've seen for the similar problems. Basically I had a working version of DBI and Sybase:DBD..

does rownumber exist ? - Hello everyone, In a response of a query, I would like to select rows from the first row to the 10th row. And then later, I would like to select rows from the 11st row to 20th row.....And so on. I know that in Oracle DB, there is something which can..
   Database Help (Home) -> Sybase All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]