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:[EMAIL PROTECTED]] > Sent: Tuesday, December 04, 2001 10:54 AM > To: [EMAIL PROTECTED] > 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 > [EMAIL PROTECTED] > -------------------- > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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