Maybe i got it! For the chronicle:
I resolved the problem decreasing the max_bdb_lock to the default value
and creating an index on the column used in the where clause of my
query. Probably mysql tried to lock the whole table because the primary
key wasn't in the where clause.
Cheers,
Marco
Marc
Hi, here's my create table:
mysql> show create table parametrivaloriplc;
++-+
| Table | Create Table|
++-+
| parametrivaloriplc | CREATE
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 |
| m
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 100 rows*/
> for (i=0; i<=100; i++){
> insert into mytable
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 i
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