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

. 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 5 rows where I do this transaction (pseudocode follows): begin work delete from mytable where myfield='boo' /*delete about

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

/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 -O bdb_max_lock=12 Any hint? Thank you, Marco Jim Winstead wrote: On 12/7/05, Marco Baroetto [EMAIL PROTECTED] wrote: Hi, I have a berkeley

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

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

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

Re: Wrap a href Tag Around Result

=view_userfirstname=MatthewMatthew/a a href=index.php?action=view_userfirstname=MarkMark/a a href=index.php?action=view_userfirstname=LukeLuke/a a href=index.php?action=view_userfirstname=JohnJohn/a I need to do this with pure SQL - no server side scripting... Thanks for your advice -- Marco