| Subject | Re: [firebird-support] Memory usage excess / leak in FBServer 2.5.4 |
|---|---|
| Author | Carlos H. Cantu |
| Post date | 2015-05-29T11:34:37Z |
Blob variable content (in memory) is static, meaning that each time you change the content of a blob variable, even a single byte change, Firebird will allocate new memory to store the whole blob content, so lots of memory can be consumed. The allocated memory is released only when the transaction commits.
[]s
Carlos H. Cantu
www.FireBase.com.br - www.firebirdnews.org
www.warmboot.com.br - blog.firebase.com.br
Hello, 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. Don't have any idea how to track down the problem. Thanks for any advice. -- joja select * from mon$memory_usage where mon$stat_group=0; MON$STAT_ID 1 MON$STAT_GROUP 0 MON$MEMORY_USED 4570256632 MON$MEMORY_ALLOCATED 5314478080 MON$MAX_MEMORY_USED 4570448304 MON$MAX_MEMORY_ALLOCATED 5314678784 select * from mon$database; MON$DATABASE_NAME D:\P2_DB\FIREBIRD\DBA9627.FDB MON$PAGE_SIZE 8192 MON$ODS_MAJOR 11 MON$ODS_MINOR 2 MON$OLDEST_TRANSACTION 35186254 MON$OLDEST_ACTIVE 35186255 MON$OLDEST_SNAPSHOT 35186255 MON$NEXT_TRANSACTION 35187662 MON$PAGE_BUFFERS 16384 MON$SQL_DIALECT 3 MON$SHUTDOWN_MODE 0 MON$SWEEP_INTERVAL 20000 MON$READ_ONLY 0 MON$FORCED_WRITES 1 MON$RESERVE_SPACE 1 MON$CREATION_DATE 2015-04-15 08:58:37.1050 MON$PAGES 250031 MON$STAT_ID 1 MON$BACKUP_STATE 0 show version; ISQL Version: WI-V2.5.4.26856 Firebird 2.5 Server version: Firebird/x86-64/Windows NT (access method), version "WI-V2.5.4.26856 Firebird 2.5" Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.4.26856 Firebird 2.5/tcp (SV-W12-L900)/P12" Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.4.26856 Firebird 2.5/tcp (SV-W12-L900)/P12" on disk structure version 11.2 |