List:General Discussion« Previous MessageNext Message »
From:Marvin Wright Date:July 14 2004 4:23pm
Subject:RE: deleting millions of records did not change the file size
View as plain text  
Run optimize table position_log

Marvin.

-----Original Message-----
From: Gil Vidals [mailto:gil.vidals@stripped]
Sent: 14 July 2004 17:04
To: mysql@stripped
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




Gil.Vidals@stripped
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/mysql?unsub=1


________________________________________________________________________
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
________________________________________________________________________
Thread
deleting millions of records did not change the file sizeGil Vidals14 Jul
  • Re: deleting millions of records did not change the file sizeDan Nelson14 Jul
  • Re: deleting millions of records did not change the file sizemos14 Jul
RE: deleting millions of records did not change the file sizeMarvin Wright14 Jul