Hi All! I have strange problem. DB MySQL 3.23.55, MyISAM table about 70 mln. record. Index file approx 50 Mb. I have delete about 40 mln. records and run optimize table. show table status get me size for this table approx 300Mb. But file on harddisk approx 1Gb. Does MySQL don't waste unused space from datafile? Dump for this table ~ 2GB :(( MAybe try delete table and restore it from dump?
WBW, Stas. --------------------------------------------------------------------- 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