Hi, could someone point me to a tutorial on when to do table locking with the BDB
tables in MySQL?
I'm running version 3.23.37 on RH7.0 (with BDB tables :) and if I attempt to do
locking within a transaction, the transaction is automatically committed leaving me
with non-working transaction code. So, what I'm wondering is do I even need to lock
the tables(I'm doing inserts and updates)? If I do, have there been any bugs with
locking inside transactions?
BTW, if I don't do the table write locking the code works fine.
this works....
========
begin work;
insert into Table (field1, field2) VALUES (2,'hi');
rollback;
========
this doesn't....it's committed anyway
========
begin work;
lock tables Table write;
insert into Table (field1, field2) VALUES (2,'hi');
unlock tables;
rollback;
========
Thanks,
Seth Hall
Student Programmer
Ohio State University Main Library
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php