Hi,
>>> In WAL mode with synchronous=NORMAL, when the user commits
>>> a transaction, it is written into the WAL file. No sync
>>> until a checkpoint happens. So if the power fails, you might
>>> lose all the transactions that have been written into the WAL
>>> file.
>> Ahha. That explains it.
On 11/25/2010 09:04 PM, Simon Slavin wrote:
>
> On 25 Nov 2010, at 2:00pm, Dan Kennedy wrote:
>
>> In WAL mode with synchronous=NORMAL, when the user commits
>> a transaction, it is written into the WAL file. No sync
>> until a checkpoint happens. So if the power fails, you might
>> lose all the
On 25 Nov 2010, at 2:00pm, Dan Kennedy wrote:
> In WAL mode with synchronous=NORMAL, when the user commits
> a transaction, it is written into the WAL file. No sync
> until a checkpoint happens. So if the power fails, you might
> lose all the transactions that have been written into the WAL
>
On 11/25/2010 08:49 PM, Simon Slavin wrote:
>
> On 25 Nov 2010, at 8:36am, Dan Kennedy wrote:
>
>> On 11/25/2010 03:24 PM, Twylite wrote:
>>>
>
> Argh. Trevor, I'm going to find Stephenie Meyer and do something she doesn't
> like.
>
>>> I am seeking technical information on the durability of
On 25 Nov 2010, at 8:36am, Dan Kennedy wrote:
> On 11/25/2010 03:24 PM, Twylite wrote:
>>
Argh. Trevor, I'm going to find Stephenie Meyer and do something she doesn't
like.
>> I am seeking technical information on the durability of transactions
>> with journal_mode=WAL and
On 11/25/2010 03:24 PM, Twylite wrote:
> Hi,
>
> I am seeking technical information on the durability of transactions
> with journal_mode=WAL and synchronous=NORMAL.
>
> Specifically, in the event of a power failure, can the following ever
> happen:
> (1) Loss of the last transaction completed.
>
6 matches
Mail list logo
