Issue Details (XML | Word | Printable)

Key: CORE-958
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Greg Kay
Votes: 0
Watchers: 0
Operations

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

Increase the maximum number of hash slots for the Lock Manager

Created: 22/Oct/06 01:50 AM   Updated: 17/Jun/07 12:10 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 2.1 Alpha 1

Time Tracking:
Not Specified

Environment: Dual CPU opteron 252, 16 Gb ram, and SuSE Linux 10.1.
Issue Links:
Relate
 


 Description  « Hide
In our current Firebird system (Classic FB 1.5.3), we have the hash slots value in the lock manager set to the maximum. Even with this, fb_lock_print indicates that we are close to the recommended figures of hash lengths. (Hash slots: 2039, Hash lengths (min/avg/max): 9/ 19/ 31.) We expect our database processing load to increase 5 to 10 times, so we will need the max hash slots limits increased appropriately (i.e., around the 32K mark).

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 24/Jan/07 06:52 PM
The limit has been increased up to 64K.