Jorge Bastos wrote: > Hum on messageblks i gained about 800MB less. > On headervalue gained 900MB less. > But the problem is dbmail_mimeparts, that has the complete email. > It has 45GB, that doesn’t corresponde to the email that is stored. > Can I consider a bug here? > I didn't run optimize on this table... I'm scared to do it :) > What do you say paul? Even without optimize this should contain the correct > size regarding the email that is stored? >
Jorge, Take a mysqldump of your data, and pipe it to another test database (simply create a new database, and let the mysql load recreate the tables there). This way you are not going to lock your tables for 48h optimization, and you will get a precise idea of what you would gain. _______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
