So, just to clarify: optimize table just defragments the index? Apologies, I misinterpreted the documentation then.
Thanks, Dan -----Original Message----- From: Baron Schwartz [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 10, 2007 3:05 PM To: Tiago Cruz Cc: Eric Frazier; Dan Rogart; mysql@lists.mysql.com Subject: Re: Saving space disk (innodb) Hi Tiago, Tiago Cruz wrote: > Thank you guys!! > > I have a lot of MyISAM and a lot of InnoDB on this database. > > I did one little "for" to run one "OPTIMIZE TABLE" in each table that I > have, on my database. > > If this step don't save enough disk space, I'll do the Baron suggestion. It will not shrink your InnoDB files a single byte :-) If you're trying to shrink those, it's a waste of time. Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
