>On Fri, Jan 19, 2001 at 06:58:34AM -0500, Bob Hall wrote:
> >
> > MySQL has only table level locking, which means that each update
> > will lock the entire table, which means that updates must be done
> > one at a time. There are a couple of open source extensions of MySQL
> > that are supposed to offer row level locking, but these aren't
> > available yet.
>
>With BDB tables, you get page-level locking, right?
Yes sir, I think you are right. BDB has to be compiled into MySQL,
and the remarks in the online documentation suggest that MySQL with
BDB compiled in isn't quite as stable as MySQL alone. Also, BDB
tables are not as fast as MySQL without BDB tables. The original
poster didn't ask about BDB tables and I don't have any experience
with them. If you do, perhaps you could describe how the performance
characteristics of MySQL with BDB tables compare with the original
poster's needs. I'd be very interested in learning about it.
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
---------------------------------------------------------------------
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
