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
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
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
Nissim Lugasy writes:
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?
OPTIMIZE TABLE is what you want. But doing it after each