Hi,
> I'm curious about the size of the messageblks table compared to the > amount of curmail_size listed in the users table. If I run the following > query (SELECT sum( curmail_size ) > FROM dbmail_users;) I get the following results (11639193048) about > 11GB. Now my messageblks table is about 25GB. 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 DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
