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
________________________________________________________________________
