At 11:04 AM 7/14/2004, you wrote:
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???
Why would it? If you delete 1 row from the middle of the table, it leaves a
hole. This space is recovered when
Run optimize table position_log
Marvin.
-Original Message-
From: Gil Vidals [mailto:[EMAIL PROTECTED]
Sent: 14 July 2004 17:04
To: [EMAIL PROTECTED]
Cc: robert gavina
Subject: deleting millions of records did not change the file size
My question in brief is why wouldn't the physical mys
In the last episode (Jul 14), Gil Vidals said:
> 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???
Automatic filesize reduction would only be possible if the deleted
records were at the end
