On Sun, 2005-05-15 at 19:48 -0700, Dan Kennedy wrote:
> Anyone have a quick summary of InnoDB algorithm for comparison? I
> suspect whatever trick they use won't work with SQLite because
> there is no server process, but it could be interesting anyway.
There are several ways the extra fsync() migh
--- Ludvig Strigeus <[EMAIL PROTECTED]> wrote:
> Quote:
>
> InnoDB must flush the log to disk at each transaction commit, if that
> transaction made modifications to the database. Since the rotation speed of
> a disk is typically at most 167 revolutions/second, that constrains the
> number of
Quote:
InnoDB must flush the log to disk at each transaction commit, if that
transaction made modifications to the database. Since the rotation speed of
a disk is typically at most 167 revolutions/second, that constrains the
number of commits to the same 167/second if the disk does not fool the
3 matches
Mail list logo