Re: Humor me: Postgresql vs. MySql (esp. licensing)

In article <20031009030518(dot)GD8265(at)dcc(dot)uchile(dot)cl>,
Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> writes:

> It was not clear to me from the article that originally mentioned it
> that it had an uncommitted transaction, though it may very well be the
> case.

Sridhar mentioned MyISAM tables - thus no transactions at all.

> But given that ROLLBACK takes some unreasonable amount of time in MySQL,
> what do you really expect? Did the rollback work when the poweroff was
> requested? Or did it work only halfway, rendering the whole
> "transaction" model useless?

Been there, done that. You can kill the MySQL server when it's
rolling back a huge transaction. When you restart it, it just
continues the rollback.