On Thu, May 17, 2001 at 12:35:09PM -0400, Seth Hall wrote:
>
> Hi, could someone point me to a tutorial on when to do table locking
> with the BDB tables in MySQL?
Why?
> 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;
> ========
Why is the lock necessary at all?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 5 days, processed 35,049,645 queries (79/sec. avg)
---------------------------------------------------------------------
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