On 08/24/2011 11:12 AM, Martín Marqués wrote:
Why aren't deltas good enough for the first 8Kb? Is there other
information in the first 8Kb that make those more important?
The fundamental problem is what's called a torn page. You write out a
8K page; only part of it actually makes it to di
El día 22 de agosto de 2011 18:39, Greg Smith escribió:
> On 08/22/2011 05:07 PM, Martín Marqués wrote:
>>
>> My question regarding your answer is, why is it important for the
>> first page after a checkpoint and not on other page writes?
>>
>
> The first time a page is written after a checkpoint,
On 08/22/2011 05:07 PM, Martín Marqués wrote:
My question regarding your answer is, why is it important for the
first page after a checkpoint and not on other page writes?
The first time a page is written after a checkpoint, when
full_page_writes is on, the entire 8K page is written out to
2011/2/17 Greg Smith :
> AI Rumman wrote:
>>
>> I can't clearly understand what FULL_PAGE_WRITE parameter is stand for.
>> Documentation suggest that If I make it OFF, then I have the chance for DB
>> crash.
>> Can anyone please tell me how it could be happened?
>
> The database writes to disk in 8
AI Rumman wrote:
I can't clearly understand what FULL_PAGE_WRITE parameter is stand for.
Documentation suggest that If I make it OFF, then I have the chance
for DB crash.
Can anyone please tell me how it could be happened?
The database writes to disk in 8K blocks. If you can be sure that you
I can't clearly understand what FULL_PAGE_WRITE parameter is stand for.
Documentation suggest that If I make it OFF, then I have the chance for DB
crash.
Can anyone please tell me how it could be happened?