The Future of Performance: Scaling

[Bradley Baetz]

On Fri, Jan 9, 2009 at 1:46 AM, Max Kanat-Alexander <mkanat at bugzilla.org> wrote:
> On Thu, 8 Jan 2009 23:41:30 -0600 "Bradley Baetz" <bbaetz at acm.org>
> wrote:
>> Any idea why? With innodb, nothing should get blocked.
>
>        There's a bug on it. I suspect that with SATA drives, copying
> to a temporary table effectively blocks the filesystem from any further
> access.

Bug #? Even if thats true you should only see an issue if lots of
stuff is being copied. I've seen similar issues, but that was on dbs
containing millions of rows with queries that had to scan all of them.

Bradley