After running in production for about seven weeks, our dumps on one of our BDB tables performed with 'mysqldump --opt' began failing with the message: 'mysqldump: Error 1030: Got error 12 from table handler when dumping table `reference` at row: 255233'. The table has about 265,000 rows.
Reviewing the error log and the MySQL doc, I see that that error message means that we should increase the bdb_max_lock variable from its default of 10000. But nowhere can I find an algorithm for calculating an appropriate value. Can anyone point me to some information on this?
(I 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://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]