From: Michael Andrewes (mandrewescommunicator.com.au)
Date: Thu Jun 03 2004 - 06:37:35 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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:Markus.Doehrsiegenia-aubi.com]
Sent: Thursday, 3 June 2004 9:28 PM
To: 'Filip Sergeys'
Cc: 'maxdblists.mysql.com'
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: markus.doehrsiegenia-aubi.com
Internet: http://www.siegenia-aubi.com
  

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/maxdb?unsub=mandrewescommunicator.com.au

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]