Re: [firebird-support] FB lock files
Hi Rudi, You did not provide all required information to give you a reasonable answer. At least, post fb_lock_print -d output. Regards, Alexey Kovyazin Try HQbird now! www.hqbird.com ++ 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/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] FB lock files
Hi Rudi. Look at this http://www.janus-software.com/fbmanual/manual.php?book=admin&topic=23 Consider to change DefaultDbCachePages in firebird.conf. You should read about this, because it depends if you use super server, classic or super classic. DatabaseGrowthIncrement is a parameter that can affect the database performance too. Hugo Eyng Em 07/12/2015 16:52, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] escreveu: 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? -- Atenciosamente, Hugo Eyng
[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?