

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 


Tue, 23 May 2000 19:55:23 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
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:

> 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


Tue, 23 May 2000 20:02:20 -0400
Ned Lilly <ned@greatbridge.com>
Re: MySQL now supports transactions ...
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


Tue, 23 May 2000 17:25:37 -0700
"Michael A. Olson" <mao@sleepycat.com>
Re: 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:
> 
> > 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

Tue, 23 May 2000 20:26:41 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: MySQL now supports transactions ...
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 :)



Tue, 23 May 2000 21:39:28 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: MySQL now supports transactions ...