# This is a sample Firebird configuration file.
#
# Where values are commented out the default value
# (which is usually show as well) applies.
#
# If commented out t
# For detailed description of all parameters refer to
# http://www.ibphoenix.com/ibp_config.html
#
#V4_LOCK_MEM_SIZE 98304
#ANY_LOCK_MEM_SIZE 98304
#V4_LOCK_SEM_COUNT 32
#ANY_LOCK_SEM_COUNT 32
#V4_LOCK_SIGNAL 16
#ANY_LOCK_SIGNAL 16
#V4_EVENT_MEM_SIZE 32768
#ANY_EVENT_MEM_SIZE 32768
#DATABASE_CACHE_PAGES 75
#SERVER_PRIORITY_CLASS 1
#SERVER_CLIENT_MAPPING 4096
#SERVER_WORKING_SIZE_MIN 0
#SERVER_WORKING_SIZE_MAX 0
#V4_LOCK_GRANT_ORDER 1
#LOCK_HASH_SLOTS 101
#DEADLOCK_TIMEOUT 10
#LOCK_ACQUIRE_SPINS 0
#CONNECTION_TIMEOUT 180
#DUMMY_PACKET_INTERVAL 60
# TMP_DIRECTORY 200000 "/opt/interbase/tmp"
TMP_DIRECTORY 2684354560 "/usr/interbase_tmp"
#EXTERNAL_FUNCTION_DIRECTORY "/opt/interbase/udf"
#TCP_REMOTE_BUFFER 8192
#CPU_AFFINITY 1
#TCP_NO_NAGLE 0
~

Enclosed above is the isc_config file. Actually at first when server
reboots the mem usage is at just 140 MB. When the first user connects to
this db the mem goes up to ~650 MB and remains there till server is
rebooted. When only FB is restarted the Mem usage comes down to ~650 MB
again.

I don't know if I can keep doing backup and restore every few hours ! My
number of users right now is just 3 and each runs one query every 2 mins
or so. I am getting nightmares thinking what will happen if there are
more users and a query being run every few seconds.

Is firebird unstable ? Do I need to start looking at MySQL or something
like that.

We are a recruitment company and keep running campaigns for customers
where we get 100's of resumes every week. 60% overwriting the old ones &
40% are new ones. We have started receiving many more and suddenly there
is this problem just when we need our db to be strong and stable.

Can people here share the maximum db sizes that they have used with FB.
Has anyone used FB database of more than 500MB without performance
problems ?

Warm regards,


RP

Artur Anjos wrote:

>Rajesh,
>
>What it's really strange is Firebird starting using more than 600Mb. Can you
>please post your ibconfig params?
>
>Artur
>
>
>
>> 6:28pm up 4:59, 2 users, load average: 0.04, 0.22, 0.19
>>55 processes: 53 sleeping, 2 running, 0 zombie, 0 stopped
>>CPU states: 8.6% user, 0.8% system, 0.0% nice, 90.5% idle
>>*Mem: 1031084K av, 637968K used, 393116K free*, 0K shrd,
>>16764K buff
>>Swap: 1044216K av, 0K used, 1044216K free 560804K
>>cached
>>
>>Clearly firebird is unable to free the memory for some reason ? What can
>>I do to improve this ?
>>
>>Warm regards,
>>
>>
>>RP
>>
>>
>>
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
>