Hello Dimitry,

Thank you.

I have checked the monitoring table, the sum of active memory usage is
160MB, the max usage around 290MB. But the firebird process takes up ca.
730MB. How can I understand this gap? Also the memory usage of the
firebird.exe increases over the time till the max of 32Bit (2GB). This
problem occurred only recently with no major changes in our database. Maybe
windowsupdates have been a part of the problem? The clients uses firebird
ODBC (MS Access) and some clients are written in C.

Thanks a lot.

-----Ursprüngliche Nachricht-----
Von: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com>
Gesendet: Dienstag, 3. September 2019 12:28
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird
memory leakage

03.09.2019 12:10, 'Check_Mail' check_mail@... [firebird-support]
wrote:

> if we use the default firebird.conf with #CpuAffinityMask = 0, does
> firebird use all cpus/cores? Or should I set it to 15 for 4 cores? I
> have found some information for the
> 2.5 only.

For Firbird 3 CPU affinity has no point.

> Does upgrading to 3.04 fix that problem or should we use the classic

server? In the future, we should install a 64 Bit Windows, but the existing
udf-files do not work with this architecture.

You must detect where problem is before one can tell for sure whether it
will be fixed or not. Start from inspecting MON$MEMORY_USAGE.
In any case 3.0.4 has a lot of bugfixes so it is better to upgrade even
if it cannot solve your memory problem.


--
WBR, SD.


------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item on the
main (top) menu. Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at
http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links