Frank Röske wrote: > > please keep in Mind, that all the keys on the Tables are also stored in > the ibd files. Also InnoDB won't reduce filesize when you delete Entrys, > you have to to an > > ALTER TABLE <tablename> ENGINE=InnoDB; > > This creates a new temporary table and copies all not deleted Entries to > it. Then it deletes the old Tablefile and replaces with the new one. > _______________________________________________ > DBmail mailing list > [email protected] > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > I'm restoring a copy of my database so when that's finishes I'll try the ALTER TABLE command when it's done. By the way isn't OPTIMIZE TABLE do the same thing by creating a temporary table with valid data and replacing the existing table with temporary table? -- View this message in context: http://old.nabble.com/Database-Size-%28messageblks%29-tp29771510p29773131.html Sent from the dbmail users mailing list archive at Nabble.com.
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
