caclulating bdb_max_lock

[Jim Hopp]

After running in production for about seven months, our dumps on one of
our BDB tables performed with 'mysqldump --quick' began failing with the 
message:
'mysqldump: Error 1030: Got error 12 from table handler when dumping 
table `reference` at row: 504979'.

We got this error about five months ago, and I set bdb_max_locks to 
20000 to fix it then.  I realize I can simply increase it to, say, 50000 
and we should be OK for another seven months.

But what I'd really like to do is calculate an appropriate value for 
bdb_max_locks.  Nowhere can I find an algorithm for calculating an
appropriate value.  Can anyone point me to some information on this?  A 
Google search has turned up only my old questions on this.

Thanks,
Jim Hopp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]