November 16th, 2004, 05:12 AM
|
|
Registered User
|
|
Join Date: May 2004
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Tuning Firebird Database for large DB on DualXeon with 2GB Ram
Hi,
I've a Compaql server with Dual Xeon and 2GB Ram
It's used for Firebird DB server with 6 database of 60-120 MB
I've just tuned the os fedora core 1 with:
1) 250 32000 288 128 on /proc/sys/kernel/sem
2) shmall = 2097152
3) shmmax = 1900000000
On normal condition (40 persons) it's more stable and efficient but when on full load (120 persons) the firebird process are 60 and it don't accept new connection on DB
I've tryed also to connect on localhost without success.
Can i improve performance of my server?
p.s. Firebird is used as classic server and the version is 1.5.1
Thanks
The firebird.conf file is this :
Quote:
#######################################
#
# Firebird configuration file
#
#######################################
# ==================================
# Settings for all platforms/engines
# ==================================
#
#RootDirectory =
# ----------------------------
# Database Paths/Directories
#
#DatabaseAccess = Full
# ----------------------------
# External File Paths/Directories
#
ExternalFileAccess = /opt/db-firebird
# ----------------------------
# External Function (UDF) Paths/Directories
#
#UdfAccess = Restrict UDF
# ----------------------------
# Temporary directories
#
#TempDirectories =
# ----------------------------
# Number of cached database pages
#
DefaultDbCachePages = 75
# ----------------------------
# In-memory sorting module
#
#SortMemBlockSize = 1048576
#
#SortMemUpperLimit = 67108864
# ----------------------------
# Backward-compatible parameter ordering as it was in FB v1/IB
#
#OldParameterOrdering = 0
# ----------------------------
# Boolean evaluation method (complete or shortcut)
#
#CompleteBooleanEvaluation = 0
# ----------------------------
#
#DeadlockTimeout = 10
# ----------------------------
#
MaxUnflushedWrites = -1
#
MaxUnflushedWriteTime = -1
# ----------------------------
#
#BugcheckAbort = 0
# ----------------------------
# Client Connection Settings (Basic)
#
ConnectionTimeout = 120
#
#DummyPacketInterval = 0
# ----------------------------
# TCP Protocol Settings
#
#RemoteServiceName = gds_db
#RemoteServicePort = 3050
#
#RemoteAuxPort = 0
#
#TcpRemoteBufferSize = 8192
#
#TcpNoNagle = 0
#
#RemoteBindAddress =
# ----------------------------
# Locking and shared memory parameters
#
#LockMemSize = 262144
#
LockSemCount = 128
#
#LockGrantOrder = 1
#
#LockAcquireSpins = 0
#
#LockHashSlots = 101
# ----------------------------
#
#EventMemSize = 65536
# ==============================
# Classic Server Engine Settings
# ==============================
#
#
# ----------------------------
# Priority level/class for the server process.
#
#ProcessPriorityLevel = 0
# ----------------------------
# Local Connection Settings
#
#IpcMapSize= 4096
#
#IpcName = FirebirdIPI
#
#RemotePipeName = interbas
#
#CreateInternalWindow = 1
# ============================
# Settings for Unix/Linux platforms
# ============================
#
#LockSignal = 16
# ----------------------------
# Remove protection against opening databases on NFS mounted volumes
#
#RemoteFileOpenAbility = 0
|
|
Dev Shed Forums Sponsor:
maybe the xinetd is limiting you
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
