Giulio Ferro wrote: > Uwe Kiewel wrote: >>> Can it be that the cause of the mess in the dbmail-messageblks >>> table? I will run it, if it can be any good... >>> >> >> Might be so. Run it twice, because of "set delete flag" and "delete >> messages". >> >> Paul can explain it better, for sure :-) >> > > Ok, I'm waiting for what he says... :-)
Run it twice to get rid of all deleted messages. If this deletes a lot of messages you should probably also run OPTIMIZE_TABLE <tablename>; for - at least - dbmail_messages and dbmail_messageblks All of this will take a long time to run. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
