Bdb tables locks are at page level, how can I determine the number of pages of my table?
mysql> show variables like '%binlog_cache_size%'; +-----------------------+------------+ | Variable_name | Value | +-----------------------+------------+ | binlog_cache_size | 32768 | | max_binlog_cache_size | 4294967295 | +-----------------------+------------+ How can I estimate the binlog chache size I need? The manual is very vague about this issue.. Thanx, Marco sheeri kritzer wrote: >Hi Marco, > >My hint is to read the BDB section of the manual: > >http://dev.mysql.com/doc/refman/5.0/en/bdb-start.html > >specifically the part that says: > >" With the bdb_max_lock variable, you can specify the maximum number >of locks that can be active on a BDB table. The default is 10,000. You >should increase this if errors such as the following occur when you >perform long transactions or when mysqld has to examine many rows to >execute a query: > >bdb: Lock table is out of available locks >Got error 12 from ... > >You may also want to change the binlog_cache_size and >max_binlog_cache_size variables if you are using large >multiple-statement transactions. See Section 5.11.3, "The Binary Log". >" > >What is your binlog_cache_size and max_binlog_cache_size? > >-Sheeri > >On 12/7/05, Marco Baroetto <[EMAIL PROTECTED]> wrote: > > >>Hi, >>I have a berkeley db table containing about 50000 rows where I do this >>transaction (pseudocode follows): >> >>begin work >>delete from mytable where myfield='boo' /*delete about 100 rows*/ >>for (i=0; i<=100; i++){ >>insert into mytable values(...); >>} >>commit >> >>During the insert command i get the following error: >>"Lock table is out of available locks" >> >>I tried to resolve the problem starting mysqld with -O >>bdb_max_lock=60000 and later with -O bdb_max_lock=120000 but i still >>receive the same error. >> >>dbd related variables follows: >> >>mysql> show variables like "%bdb%"; >>+---------------------+--------------------------------------------------------+ >>| Variable_name | >>Value | >>+---------------------+--------------------------------------------------------+ >>| bdb_cache_size | >>8388600 | >>| bdb_home | >>/var/lib/mysql/ | >>| bdb_log_buffer_size | >>32768 | >>| bdb_logdir >>| | >>| bdb_max_lock | >>120000 | >>| bdb_shared_data | >>OFF | >>| bdb_tmpdir | >>/tmp/ | >>| have_bdb | >>YES | >>| version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (May 13, >>2005) | >>+---------------------+--------------------------------------------------------+ >>9 rows in set (0.00 sec) >> >>Any hint is welcome.. >> >>Thanx in advance for the help, >>Marco >> >>-- >>MySQL General Mailing List >>For list archives: http://lists.mysql.com/mysql >>To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
