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 here?
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 degradation. Just
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.23.58, we
-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 tables at the huge rate
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 to make the
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
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 application
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 found
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 found a post here where someone
had a similar