On Tue, Feb 04, 2003 at 01:27:13PM +0200, Okan CIMEN wrote: > Hi all, > > First of all , the version of mysql is 3.23.52. I am using When I do a > truncate table on a MyIsam table, the show table command shows thatt there > are no records but the table size is about 100 MBs. > > Afterwards, I run an optimize table command and the table size decreases to > 2KB's. Everything seems OK but the table_name.MYI and table_name.MYD file > sizes are still about 100MB's. > > When I run all these on 3.23.49 everything works fine. Has anyonew > experienced the same problem ?
Hi Okan, Could you submit a bug report - others have reported the same problem, but we are still working on fixing them. A bug report will help us find the problem more quickly. For more information, see http://www.mysql.com/doc/en/Bug_reports.html Cheers! -- Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Find the highest score for a given name mysql> SELECT name, max(score) FROM high_score GROUP BY name; "Gosh, Batman. The nobility of the almost-human porpoise." --Robin, the Boy Wonder --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
