Hi!

----- Original Message -----
From: "Balteo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 01, 2002 7:12 AM
Subject: Innodb's inner workings and checkpoints


> Hello,
>
> Can data be flushed from the buffer pool to the main innodb tablespace
> (checkpoint) but not be present yet in the innodb log files? In other
> words can a checkpoint occur before the data is flushed from the log
> buffer to the disk logs?

No, the log segment for a modified page is always written to disk before the
page is flushed from the buffer pool. This is called 'force log to disk' in
literature.

> Thanks in advance,
>
> Balteo.

Best regards,

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to