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 ? Regards Okan MyDBA :) --------------------------------------------------------------------- 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