Do you HAVE a memory problem? Or are you upset about Firebird using this
amount of RAM?
On 03/06/2015 09:48, 'Jojakim Stahl' joja.li...@jojakim.de
[firebird-support] wrote:
Hello,
still no solution. Running since last Friday, fbserver.exe grew up to
+3GB memory so far. Few minutes ago, I stopped all our services, it
remained only one attachment from isql to select mon$memory_usage:
memory did not went down. IMHO, this memory leak is not caused by a
client leaving open something, otherwise the memory should go down
when the connection is closed, shouldn't it?
SQL> select cast('NOW' as timestamp) TS, m.*, (select count(*) from
mon$attachme
nts) ATTACHMENTS, (select count(*) from mon$statements) STATEMENTS
from mon$memo
ry_usage m where m.mon$stat_group=0;
TS 2015-06-03 14:04:02.3910
MON$STAT_ID 1
MON$STAT_GROUP 0
MON$MEMORY_USED 3329950624
MON$MEMORY_ALLOCATED 3870920704
MON$MAX_MEMORY_USED 3331189248
MON$MAX_MEMORY_ALLOCATED 3870990336
ATTACHMENTS 1
STATEMENTS 1
Any hints how to investigate this problem?
Thank you.
--
joja
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Freitag, 29. Mai 2015 12:03
An: firebird-support@yahoogroups.com
Betreff: AW: [firebird-support] Re: Memory usage excess / leak in
FBServer 2.5.4
> ---In firebird-support@yahoogroups.com, <joja.lists@...> wrote :
>
> I'm facing a problem where the firebird server v2.5.4 on win 2012
server in superserver mode is leaking > memory. Currently I'm at ~5GB
usage.
I just restarted our services: FB memory usage went down to normal values:
MON$STAT_ID 1
MON$STAT_GROUP 0
MON$MEMORY_USED 145842736
MON$MEMORY_ALLOCATED 152465408
MON$MAX_MEMORY_USED 147606936
MON$MAX_MEMORY_ALLOCATED 154570752
>1. Show us results of
>select count(*) form mon$attachments
Before restart: 11
After restart: 11
>select count(*) form mon$transactions
Before restart: 0
After restart: 3
>select count(*) form mon$statements
Before restart: 84
After restart: 122
>2. Do you use any custom UDF's ?
No
--
Joja
