> > > I made a mistake, but every day increases the engine between 50 and > > 100 mb, not Kb. > > > > > > If i disconnect all users and start To work, the memory used is less > > than 400 Mb in 2 days, and after 2 weeks is 1,4 Gb. > > Please try the following experiment. When memory used is >1Gb, make one > single new connection, and after it ask everyone to disconnect from the > database. What will be memory consumption after it? > > And one more check question - do you use any UDFs? How is memory > allocated in them? Is not it plain malloc() instead ib_util_malloc()? >
Hello, i have done it. Las monday evening i restarted all users, and today i have 760244K of private bytes and 602664K of Working set. Yesterday i had around 500000K of use. I have connected as sysdba, without executing anything, disconnect all users and i have seen that the records in memory usage have decreased, but the memory used is the same. I have executed: select * from mon$transactions select * from mon$memory_usage select * from mon$attachments select * from mon$statements select m.*, s.* from mon$memory_usage m left outer join mon$statements s on (m.mon$stat_id = s.mon$stat_id ) select m.*, t.* from mon$memory_usage m left outer join mon$transactions t on ( m.mon$stat_id = t.mon$stat_id ) select m.*, a.* from mon$memory_usage m left outer join mon$attachments a on ( m.mon$stat_id = a.mon$stat_id ) I attach you the results in excel format, but is strange that there are rows in mon$memory_usage that has a lot of memory allocated, but the user SYSDBA, has only executed the above statements. Jesus Garcia
fbmemory.rar
Description: application/rar
------------------------------------------------------------------------------ EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
