Re: transaction with bdb table gives error "Lock table is out of available locks"

Marco Marco Baroetto wrote: >Hi, here's my create table: > >mysql> show create table parametrivaloriplc; >++-+ >| Table

Re: transaction with bdb table gives error "Lock table is out of available locks"

run/mysqld/mysqld.pid -O bdb_max_lock=12 mysql 9184 33.6 3.3 179136 70148 ? Sl 01:00 177:45 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock

Re: transaction with bdb table gives error "Lock table is out of available locks"

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, &

Re: Wrap Tag Around Result

Mark >Luke >John > >I need to do this with pure SQL - no server side scripting... > >Thanks for your advice > > > > > -- Marco Baroetto Parisi Ribes Informatica - Via Jervis, 60 - 10015 Ivrea (TO) - Italy Tel: +39-0125-62.78.50 - Fax: +39-0125-64.44.39 Web: http:

transaction with bdb table gives error "Lock table is out of available locks"

Hi, I have a berkeley db table containing about 5 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