Subject AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4
Author Jojakim Stahl
> ---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