caclulating bdb_max_lock

2004-08-18 Thread Jim Hopp
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]

bdb tables: calculating an appropriate value for bdb_max_lock

2004-02-24 Thread Jim Hopp
gather, since --opt means --lock-tables and BDB tables are locked at the page level that I'll need enough locks to cover all the pages in the largest table. How can I determine how many pages are in a table?) Thanks, Jim Hopp -- MySQL General Mailing List For list archives: http

bdb tables: calculating bdb_max_lock

2004-02-21 Thread Jim Hopp
see that that error message means that we should increase the bdb_max_lock variable from its default of 1. But nowhere can I find an algorithm for calculating an appropriate value. Can anyone point me to some information on this? Thanks, Jim Hopp -- MySQL General Mailing List For list

binary update log: configure by database, not daemon?

2002-05-27 Thread jim hopp
binary update log for each database. Is there any simple way to restore and apply updates to one database on the server but not any of the others? We're running MySQL-max 3.23-49 with BDB tables on both RedHat linux 6.2 (for production) and Win 2000/XP (for development). Thanks, Jim Hopp [EMAIL