mysql:5568
From: SUGAWARA Hajime <SUGAWARA Hajime <sugawara@xxxxxxxxxx>>
Date: Tue, 28 May 2002 12:24:36 +0900
Subject: [mysql 05568] Re: OPTIMIZE で最適化できません。
菅原です。 > > 菅原です。 > > 少なくともこちらではoptimize tableしても同じ値を返しますけど……。 > 実行したSQLは下記の通りです。 > サーバのバージョンはMySQL 3.23.43です。 とのことでしたので更新履歴を見てみましたら > F.2.5 Changes in release 3.23.45 > > (UPDATE|DELETE) ...WHERE MATCH bugfix > shutdown should now work on Darwin (Mac OS X). > Fixed core-dump when repairing corrupted packed MyISAM files. > --core-file now works on Solaris. > Fix a bug which could cause InnoDB to complain if it cannot find free > blocks from the buffer cache during recovery. > Fixed bug in InnoDB insert buffer B-tree handling that could cause > crashes. > Fixed bug in InnoDB lock timeout handling. > Fixed core dump bug in ALTER TABLE on a TEMPORARY InnoDB table. > Fixed bug in OPTIMIZE TABLE that reset index cardinality if it was up > to date. > Fixed problem with t1 LEFT_JOIN t2 ... WHERE t2.date_column IS NULL > when date_column was declared as NOT NULL. > Fixed bug with BDB tables and keys on BLOB's. > Fixed bug in MERGE tables on OS with 32 bit file pointers. > Fixed bug in TIME_TO_SEC() when using negative values. とありました。 サーバの更新をしましょう :) ------ 菅原はじめ@ホビー・データ sugawara@xxxxxxxxxx
5533 2002-05-22 22:14 [<office@xxxxxxxxxx> ] OPTIMIZE で最適化できません。 5540 2002-05-23 23:01 ┗[<moeru@xxxxxxxxxx> ] 5542 2002-05-24 02:20 ┗[<office@xxxxxxxxxx> ] 5543 2002-05-24 11:21 ┗[SUGAWARA Hajime <sug] 5564 2002-05-27 23:17 ┗[<office@xxxxxxxxxx> ] -> 5568 2002-05-28 12:24 ┗[SUGAWARA Hajime <sug]