David,
According to the documentation, OPTIMIZE will also work on InnoDB tables.
Will that produce the same result as your ALTER TABLE ?
Cheers
Terry
- Original Message -
> Hi Chris,
>
> For MyISAM/BDB tables use OPTIMIZE TABLE ;
> For InnoDB tables try ALTER TABLE TYPE=InnoDB;
>
>
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
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 deleted ones,
MySQL will re-use the space freed by deletions with no special actions on
your part. Of course, if you are not going to replace the deleted records,
the
Hi Chris,
For MyISAM/BDB tables use OPTIMIZE TABLE ;
For InnoDB tables try ALTER TABLE TYPE=InnoDB;
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Mes
