MySQL now supports transactions ...

Apparently by way of some Berkeley DB code....

http://web.mysql.com/php/manual.php3?section=BDB

The Hermit Hacker wrote:

At 08:02 PM 5/23/00 -0400, you wrote:

Apparently by way of some Berkeley DB code....

http://web.mysql.com/php/manual.php3?section=BDB

Yeah, that's correct. As there was no existing transaction layer in
place, it was pretty straightforward to add Berkeley DB. They had
to abstract the ISAM layer that they've used to date, but there were
no serious technical issues.

You can choose which kind of tables you want (myisam or bdb) at
table creation time. BDB tables have the standard ACID properties
that Berkeley DB provides generally, via the standard mechanisms
(two-phase locking, write-ahead logging, and so forth).

The 3.23.16 release is decidedly alpha, but is in good enough
shape to distribute. My bet is that we'll hammer out a few dumb
bugs in the next weeks, and they'll cut something more stable
soon.

You need to download the 3.1.5 distribution of Berkeley DB from
MySQL.com. We're not distributing that version from Sleepycat.
We're in the middle of the release cycle for our 3.1 release, and
expect to cut a stable one in the next week or so. MySQL relies
on a couple of features we added to 3.1 for them, so they can't
run with the 3.0 release that's up on our site now.

It's been pretty quiet since my message on Sunday, about the
difficulties in integrating Berkeley DB with the PostgreSQL backend.
Vadim (and others), what is your opinion? My impression is that
the project is too much trouble, but I'd be glad to hear from you
folks on the topic.

mike

Apparently by way of some Berkeley DB code....

http://web.mysql.com/php/manual.php3?section=BDB

The Hermit Hacker wrote:

http://www.mysql.com/download_3.23.html

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org

Yes, I see that too. It makes much more sense for them because they
have ordered heaps anyway, with secondary indexes, rather than our
unordered heap and indexes.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

On Tue, 23 May 2000, Bruce Momjian wrote:

Apparently by way of some Berkeley DB code....

http://web.mysql.com/php/manual.php3?section=BDB

The Hermit Hacker wrote:

http://www.mysql.com/download_3.23.html

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org

Yes, I see that too. It makes much more sense for them because they
have ordered heaps anyway, with secondary indexes, rather than our
unordered heap and indexes.

Just figured a heads up was in order for those that have been using
ACID/transactions in their arguments :)