4 messages in com.mysql.lists.mysqlRE: Size of table's MYD file?
FromSent OnAttachments
Nissim Lugasy04 Dec 2001 09:53 
Jon Gardiner04 Dec 2001 10:07 
Mike(mickalo)Blezien04 Dec 2001 10:13 
Carl Troein04 Dec 2001 10:22 
Subject:RE: Size of table's MYD file?
From:Jon Gardiner (jo@mycomputer.com)
Date:12/04/2001 10:07:21 AM
List:com.mysql.lists.mysql

Shrinking the database immediately would be too slow for most purposes. When you delete a record the database flags it as ready to be recycled. Inserts will always try to recycle a deleted slot where possible. If you delete a really big block of records and want to reclaim the disk space you can run "optimize table your_table" to force mysql to rebuild the table.

Jon Gardiner.

-----Original Message----- From: Nissim Lugasy [mailto:lug@lerc.nasa.gov] Sent: Tuesday, December 04, 2001 10:54 AM To: mys@lists.mysql.com Subject: Size of table's MYD file?

Why is it that when I delete records from a table in the database, the size of the table's MYD file does not get smaller. It's still the original size. Do I have to flush the table to get the accurate size?

Thanks

-------------------- Nissim Lugasy 216-433-2708 lug@grc.nasa.gov

--------------------

--------------------------------------------------------------------- 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 <mysq@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-jong=myco@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php