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 your table name;
For InnoDB tables try ALTER TABLE your
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,
PROTECTED]
Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
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 deleted ones,
MySQL will re-use
Hi Chris,
For MyISAM/BDB tables use OPTIMIZE TABLE your table name;
For InnoDB tables try ALTER TABLE your table name 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