From: Sagi Bashari (sagi_at_nonexisting.hamakor.org.il)
Date: Thu 17 Jun 2004 - 19:50:10 IDT
On 17/06/2004 19:12, Shachar Shemesh wrote:
> Sagi Bashari wrote:
>
>> I can only speak from my experience. I never lost any data because of
>> MySQL. MySQL supports transactions for few years now so this is not
>> an issue for me.
>
>
> I was mainly referring to data integrity in the face of power
> failure/server segmentation fault in the middle of a transaction.
> These are the type of problems that are extremely uncommon, but
> extremely dangerous for that very same reason.
>
> Pg's disk data structure is built like a journaled file system, in
> order to give an assurance against precisely these type of problems.
> As far as I understood, MySQL's speed comes precisely from the lack of
> this structure. To me, these are more important than logical
> transactions when everything is ok. That is also what I meant when I
> said I'm not sure how you can retrofit such features into an existing
> database.
I believe InnoDB offers the same advantages. You may read about it here:
http://www.innodb.com/howtouse.php
Sagi
=================================================================
To unsubscribe, send mail to linux-il-request_at_linux.org.il with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail linux-il-request_at_linux.org.il
This archive was generated by hypermail 2.1.7 : Thu 17 Jun 2004 - 20:05:09 IDT