Hi!
On Aug 10, Jeremy Zawodny wrote:
> On Wed, Aug 04, 2004 at 04:32:42PM +0300, Egor Egorov wrote:
> > > Since 4.0.17 MySQL sync()'s after it created an .frm file (in
> > > CREATE/ALTER TABLE).
> >
> Wouldn't it make more sense to use fsync() on just the .frm file? Or
> am I missing something
On Wed, Aug 04, 2004 at 04:32:42PM +0300, Egor Egorov wrote:
> Sergei Golubchik <[EMAIL PROTECTED]> wrote:
>
> >> We're upgrading from 3.23.58 to 4.0.20 and found that that although the
> >> ALTER test results of sql-bench had been greatly improved, CREATE has
> >> shown nasty performance degradat
> On other hand B->C changes for some tests surprise me. Are the
> results stable if you repeat the run ? In some cases especially
> for short tests deviation can be pretty large.
The results are stable, sadly. The bigger surprise was the select
deviation from 3 to 4, but so far, in applicat
On Mon, 2004-08-02 at 14:57, Tinley, Jeremy wrote:
> We're upgrading from 3.23.58 to 4.0.20 and found that that although the
> ALTER test results of sql-bench had been greatly improved, CREATE has
> shown nasty performance degradation. Just before needing to make the
> decision to revert back to 3
Hi!
On Aug 04, Egor Egorov wrote:
> Sergei Golubchik <[EMAIL PROTECTED]> wrote:
>
> >> We're upgrading from 3.23.58 to 4.0.20 and found that that although the
> >> ALTER test results of sql-bench had been greatly improved, CREATE has
> >> shown nasty performance degradation. Just before needing
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 04, 2004 8:33 AM
To: [EMAIL PROTECTED]
Subject: Re: CREATE performance degradation from 4.0.17 -> 4.0.20
Sergei Golubchik <[EMAIL PROTECTED]> wrote:
> As one usually doesn't create t
Sergei Golubchik <[EMAIL PROTECTED]> wrote:
>> We're upgrading from 3.23.58 to 4.0.20 and found that that although the
>> ALTER test results of sql-bench had been greatly improved, CREATE has
>> shown nasty performance degradation. Just before needing to make the
>> decision to revert back to 3.2
Hi!
On Aug 02, Tinley, Jeremy wrote:
> We're upgrading from 3.23.58 to 4.0.20 and found that that although the
> ALTER test results of sql-bench had been greatly improved, CREATE has
> shown nasty performance degradation. Just before needing to make the
> decision to revert back to 3.23.58, we fo