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 a post here where someone
> had a similar problem when using SAN storage. We see the problem using
> hardware RAID, shared storage or local SCSI disks.
Yes.
Since 4.0.17 MySQL sync()'s after it created an .frm file (in
CREATE/ALTER TABLE).
As one usually doesn't create tables at the huge rate, it is not a
problem.
Unfortunately, it is apparently a problem for sql-bench :(
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
