Re: CREATE performance degradation from 4.0.17 - 4.0.20

2004-08-11 Thread Sergei Golubchik
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?

Re: CREATE performance degradation from 4.0.17 - 4.0.20

2004-08-10 Thread Jeremy Zawodny
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

Re: CREATE performance degradation from 4.0.17 - 4.0.20

2004-08-04 Thread Egor Egorov
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

RE: CREATE performance degradation from 4.0.17 - 4.0.20

2004-08-04 Thread Tinley, Jeremy
-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

Re: CREATE performance degradation from 4.0.17 - 4.0.20

2004-08-04 Thread Sergei Golubchik
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

Re: CREATE performance degradation from 4.0.17 - 4.0.20

2004-08-04 Thread Peter Zaitsev
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

RE: CREATE performance degradation from 4.0.17 - 4.0.20

2004-08-04 Thread Tinley, Jeremy
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

Re: CREATE performance degradation from 4.0.17 - 4.0.20

2004-08-03 Thread Sergei Golubchik
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

CREATE performance degradation from 4.0.17 - 4.0.20

2004-08-02 Thread Tinley, Jeremy
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