Hi,

Thanks, your backup settings are similar to mine. I will keep this in mind.

What prompted you to increase the settings in sysctl.conf? Was it problems
similar to mine? Or prior knowledge/documents?


Regards
Michael Andrewes 

-----Original Message-----
From: Döhr, Markus ICC-H [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 3 June 2004 9:28 PM
To: 'Filip Sergeys'
Cc: '[EMAIL PROTECTED]'
Subject: RE: SapDB 7.4 regular crash on backup

We're running also 8 GB DB Server (SAP) with the following settings in
/etc/sysctl.conf

# Kernel settings (for SAP R/3)
#
kernel.shmmax=4113682943
kernel.sem=4096 512000 1600 2048
kernel.msgmax=16384
kernel.shmall=4113682943
kernel.msgmni=1024
vm.heap-stack-gap=256

Shared memory and IPC parameters for central instance (Database + R/3)


net.core.rmem_max=8388608
net.core.wmem_max=8388608
net.core.wmem_default=8388608
net.core.rmem_default=8388608
net.core.netdev_max_backlog=4096
net.ipv4.tcp_rmem = "4096 87380 4194304"
net.ipv4.tcp_wmem = "4096 87380 4194304"
net.ipv4.tcp_mem = "4096 87380 4194304"


All the "net.*"-parameter helped us in speeding up our backup by 20 %. We do
that backup via separate network segment with GBit-Ethernet. This has to be
changed then of course on the backup server too and the interfaces have to
be reinitialized (/etc/init.d/network restart).


Greetz,


SIEGENIA-AUBI KG
Informationswesen
 
i.A.
 
Markus Döhr
SAP-CC/BC, SAPDB-DBA

Tel.:    +49 6503 917-152
Fax:     +49 6503 917-7152
E-Mail: [EMAIL PROTECTED]
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]



--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to