Monday, 7 December 2015

[firebird-support] FB lock files

 

I noticed our biggest data server have a lot of hard disk activity creating fb_lock files.

Firebird 2.5.4, superclassic

My changed lock configurations are :

 

#LockMemSize = 1048576

LockMemSize = 10097152

#LockHashSlots = 1009

LockHashSlots = 60589

 

Should I try to set them higher? If so, whats a good parameter to know by how much I should increase it?

__._,_.___

Posted by: =?iso-8859-1?Q?Rudi_Feij=F3?= <rudi.feijo@multidadosti.com.br>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

.

__,_._,___

No comments:

Post a Comment