So what is the problem with changing this to 10009 by example? What is the drawback? Em 03/09/2013 15:51, "Dmitry Kuzmenko" <[email protected]> escreveu:
> ** > > > Hello, Fabiano! > > Tuesday, September 3, 2013, 9:38:47 PM, you wrote: > > FDS> Mutex wait: 37.6% > FDS> Hash slots: 1009, Hash lengths (min/avg/max): 74/ 98/ 128 > FDS> Terrible numbers. Then I disconnect everything, chang LockHashSlots in > FDS> Firebird.conf to 4093 (more or less 4 times more that default 1009 > and still > FDS> a prime number) and now the HDD is running smoth! > > Yes, we have several cases at different production environments with > high load (Windows, Linux), and found that high LockHashSlots value helps > a lot. > > The good value is around 10000. > > BTW, Firebird 1.5 ignores value higher than 2048, IIRC. > Other Firebird versions accepts higher values without problems. > > -- > Dmitry Kuzmenko, www.ib-aid.com > > > [Non-text portions of this message have been removed] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
