Issue Details (XML | Word | Printable)

Key: CORE-3791
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Nickolay Samofatov
Votes: 0
Watchers: 8
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Performance degrades when actively working with databases bigger than the available RAM amount

Created: 18/Mar/12 08:20 AM   Updated: 02/Jul/13 10:14 AM
Component/s: Engine
Affects Version/s: 2.1.0, 2.1.1, 2.0.5, 2.1.2, 2.1.3, 3.0 Initial, 2.0.6, 2.5.0, 2.1.4, 2.5.1
Fix Version/s: 2.1.5, 2.5.2, 3.0 Alpha 1

Environment:
Firebird (both 32-bit and 64-bit) on Windows 64-bit hosts.
Windows 2008 and Windows 7 are known to be affected, Windows 2003 R2 is suspected.
Issue Links:
Relate
 


 Description  « Hide
With the random file access requested, the Windows file-system cache is growing so that it could fit all the accessed pages. If the whole database is being accessed (e.g. by the backup process or just very random I/O pattern) and its size is larger than either the configured FileSystemCacheSize setting or the available RAM size, the swapping occurs. In the worst case it leads to the shrinked working set of the Firebird server itself but sometimes even Windows itself can go out of the available physical memory and crash.

Confirmation by Microsoft:
http://support.microsoft.com/kb/2549369


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Repository Revision Date User Message
Firebird #54256 Tue Mar 27 07:08:25 UTC 2012 dimitr Fixed CORE-3791: Performance degrades when actively working with databases bigger than the available RAM amount.
Files Changed
MODIFY /firebird/branches/B2_1_Release/src/common/classes/TempFile.cpp
MODIFY /firebird/branches/B2_1_Release/src/jrd/os/win32/winnt.cpp
MODIFY /firebird/branches/B2_1_Release/src/utilities/gstat/dba.epp

Repository Revision Date User Message
Firebird #54257 Tue Mar 27 07:10:19 UTC 2012 dimitr Fixed CORE-3791: Performance degrades when actively working with databases bigger than the available RAM amount.
Files Changed
MODIFY /firebird/branches/B2_5_Release/src/utilities/gstat/dba.epp
MODIFY /firebird/branches/B2_5_Release/src/common/classes/TempFile.cpp
MODIFY /firebird/branches/B2_5_Release/builds/install/misc/firebird.conf.in
MODIFY /firebird/branches/B2_5_Release/src/jrd/os/win32/winnt.cpp
MODIFY /firebird/branches/B2_5_Release/src/common/config/config.cpp

Repository Revision Date User Message
Firebird #54259 Tue Mar 27 07:24:55 UTC 2012 dimitr Fixed CORE-3791: Performance degrades when actively working with databases bigger than the available RAM amount.
Files Changed
MODIFY /firebird/trunk/builds/install/misc/firebird.conf.in
MODIFY /firebird/trunk/src/jrd/os/win32/winnt.cpp
MODIFY /firebird/trunk/src/common/config/config.cpp
MODIFY /firebird/trunk/src/utilities/gstat/dba.epp
MODIFY /firebird/trunk/src/common/classes/TempFile.cpp