gt; From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 9 March 2005 9:19 AM
> To: mysql@lists.mysql.com
> Subject: Compressing after Deletion
>
> I have looked in the documentation and either I am not looking for the
> right thing or have simply overlooked it
MAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>;
Sent: Wednesday, March 09, 2005 4:43 AM
Subject: RE: Compressing after Deletion
Note that with MySQL, unlike some other databases, you don't have to do
this. If you are going to add new records to replace the de
noDB tables try ALTER TABLE TYPE=InnoDB;
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 9 March 2005 9:19 AM
> To: mysql@lists.mysql.com
> Subject: Compressing after Deletion
>
> I have looked in the documentati
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, 9 March 2005 9:19 AM
To: mysql@lists.mysql.com
Subject: Compressing after Deletion
I have looked in the documentation and either I am not looking for the
right thing or have simply overlooked it. But my question is this
I have looked in the documentation and either I am not looking for the
right thing or have simply overlooked it. But my question is this, I have
a database with 35 Million records, and I need to delete about 25 million
of those. After deletion I would think that I would need to compress,
shrink, or
