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 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 4259 - Fax > > > -----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 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 otherwise optimize the database. How is that done? do I need > to > do it? What commands should I be looking up in the docs? > > Any help is greatly appreciated. > > Chris Hood > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]