|Subject||Re: [firebird-support] Re: FB3 Memory usage|
On 3 November 2016 at 15:47, Dmitry Yemanov dimitr@... [firebird-support] <email@example.com> wrote:
03.11.2016 09:37, Si Carter wrote:
> I recently installed FB v126.96.36.199609 on Windows server 2008.
> This is a dual installation as I still have 2.5.3 installed.
> I noticed that my fb3 service is using in excess of 4gb memory
How did you get that number?
> Given this sql
> SELECT ma.MON$ATTACHMENT_NAME, ma.MON$USER, a.MON$STAT_ID,
> a.MON$STAT_GROUP, a.MON$MEMORY_USED, a.MON$MEMORY_ALLOCATED,
> a.MON$MAX_MEMORY_USED, a.MON$MAX_MEMORY_ALLOCATED
> FROM MON$MEMORY_USAGE a
> LEFT JOIN MON$ATTACHMENTS ma ON (ma.MON$STAT_ID = a.MON$STAT_ID)
> ORDER BY ma.MON$ATTACHMENT_NAME
> it produces the following results, STAT_ID 1 is the one I am more
> concerned about at this point.
> [null] [null] 138 2 3248 0 4272 0
> [null] [null] 115 2 44048 0 440480
> [null] [null] 218 3 22104 8112 87984 73688
> [null] [null] 116 3 22384 8112 91760 73688
> [null] [null] 95 3 21192 24336 2121800 2121568
> [null] [null] 1 0 58128176 81557240 1685336336 2771125200
I see that the database utilizes only 81MB of memory (with a 2.8GB peak
somewhen in the past).
> Previously it was using in excess of 5gb of ram, a restart bought it
> back to normal, but it soon escalated to 3gb (within seconds) and now to
> 4gb ram.
I don't see 4GB here, sorry.
> The database has only 4 normal connections, plus Cache Writer and
> Garbage Collector, so it's not under unusual usage at the mo.
Number of connections does not directly affect memory usage.