Run optimize table position_log Marvin.
-----Original Message----- From: Gil Vidals [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 17:04 To: [EMAIL PROTECTED] Cc: robert gavina Subject: deleting millions of records did not change the file size My question in brief is why wouldn't the physical mysql files change in size if a substantial percentage of the records are deleted from a given table??? I have a table which contained 13.5 million records. I then deleted 6.5 million records; however, the physical file size did not change. The file size before was: 12K -rw-rw---- 1 mysql mysql 8.7K Nov 28 2003 position_log.frm 1006M -rw-rw---- 1 mysql mysql 1005M Jul 13 15:42 position_log.MYD 233M -rw-rw---- 1 mysql mysql 232M Jul 13 15:43 position_log.MYI The file size after deleting 6.5 M records is: -rw-rw---- 1 mysql mysql 8.7K Nov 28 2003 /data1/mysql/positionresearch/position_log.frm -rw-rw---- 1 mysql mysql 1005M Jul 14 07:32 /data1/mysql/positionresearch/position_log.MYD -rw-rw---- 1 mysql mysql 232M Jul 14 07:32 /data1/mysql/positionresearch/position_log.MYI [EMAIL PROTECTED] Position Research, Inc. Search engine results by research tel: (760) 480-8291 fax: (760) 480-8271 www.PositionResearch.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ********************************************************************** ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
