With INNODB you need to run optimize table dbmail_mimeparts to reclaim space. Deleted rows do not get overwritten, just lost from the index. Optimizing will copy all active rows to a new file and then swap them, and delete the original table. So you need to have enough free space for the data during the copy. I think there has also been some fixes in dbmail-util since 2.3.2 to help cleanup rows.
-Jon Jorge Bastos wrote: > > Paul, > > I need a help from you. > > My db keeps growing more and more, in the version that I’m using, > 2.3.2 has a bug that isn’t deleting the emails, but after this I > added, helped by you, after the script run this query: > > DELETE dbmail_mimeparts.* FROM dbmail_mimeparts LEFT JOIN > dbmail_partlists ON (dbmail_mimeparts.id=dbmail_partlists.part_id) > WHERE dbmail_partlists.physmessage_id IS NULL; > > Thing is, db keeps growing, is there something else I can do to delete > the DELETED emails? Some other query? > > The table that is growing is dbmail_mimeparts. > > Before the query I showed I’m running dbmail-util like this: > > /usr/local/sbin/dbmail-util -d -y > > /usr/local/sbin/dbmail-util -p -y > > /usr/local/sbin/dbmail-util -ty > > Jorge, > > > -- > Scanned for viruses and dangerous content by *MailScanner* > <http://www.mailscanner.info/> > ------------------------------------------------------------------------ > > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev > -- Scanned for viruses and dangerous content by MailScanner _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
