On Tue, 04 Dec 2001 12:53:33 -0500, Nissim Lugasy <[EMAIL PROTECTED]>
wrote:

>>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?

run OPTIMIZE on the table. that usually corrects that.


Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


---------------------------------------------------------------------
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

Reply via email to