Hello John, You can increase the block size used by MaxDB in the property of your backup medium (DBMGUI -> Instance -> Backup -> Backup Medium -> <pipe medium> -> Extended -> Block Size. The default is 8 pages, that means 64 Kbyte.
The usual problem with pipes though is, that the operating system is limiting the size of the buffer used for a pipe and that the 64 Kbyte used by MaxDB is already larger then the buffer used by the operating system. One should be able to change the buffer size used by the operating system. At least HP should know how to do it. 10 GByte in 40 minutes is only 4.2 MByte/s - there should be more to it, than just a limiting pipe performance. A little test with one pipe on our HP-UX machine showed a transfer speed between 280 and 580 MByte/s. I would suggest some test: A) Test of pipe performance on your machine: mkfifo pipe pipe2file -d test2pipe -p pipe -s 10000000000 pipe2file -d pipe2file -p pipe -readonly -showspeed B) Test the read performance of your MaxDB: mkfifo pipe dbmcli -d ... -u ...,... backup_start <pipemedium> pipe2file -d pipe2file -p pipe -readonly -showspeed C) Test the speed of your backint/tape combination (a sample of the backint call can be found in dbm.ebl): mkfifo pipe pipe2file -d test2pipe -p pipe -s 10000000000 create input file containing the absolute pipe name followed by #PIPE (e.g. "/tmp/pipe #PIPE") backint -u ... -f backup -t file -p ... -i <input file> Best regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: Cappellano, John J Sent: Mittwoch, 8. November 2006 19:19 To: Simon Matter; Döhr, Markus ICC-H Cc: maxdb Subject: RE: Pipe Question during Backup Thanks -----Original Message----- From: Simon Matter Sent: Wednesday, November 08, 2006 1:16 PM To: Döhr, Markus ICC-H Cc: Cappellano, John J; maxdb Subject: RE: Pipe Question during Backup >> I am backing up via the DBM Gui to a pipe on HP-UX 11.11 (7.5 database >> release). The pipe is sending 8k chunks at a time. Is there a way to >> increase the chunks being sent to the pipe to help increase the backup >> speed. Currently 10g of data backed up via the pipe to a gigabyte line >> in 40 minutes using Galaxy software (Commvault). > > What you can try to do is to take the content of the pipe via 'dd' and > pipe > that to another pipe. There you can give the "dd" a bigger blocksize. Depending on how the data stream is handled by the backup software, you may also want to use buffering on the database servers side. I can really recommend mbuffer for that kind of task. Another nice thing is that it also lets you "visualize" the data flow. You can find it here: http://www.maier-komor.de/mbuffer.html Similar tools are pipemeter and pv: http://spamaps.org/pipemeter.php http://www.ivarch.com/programs/pv.shtml Regards, Simon > > Greetz, > SIEGENIA-AUBI KG > Informationswesen > > i.A. > > Markus Döhr > SAP-Competence Center/Basis > > Tel.: +49 6503 917-152 > Fax: +49 6503 917-7152 > Internet: http://www.siegenia-aubi.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
