On Sat, 27 Nov 2004 17:48:57 +0100, Stefano Radice <[EMAIL PROTECTED]> wrote: > Hello, > > I'm using DBMail 2.0.1, MySQL 4.0.21 with Innodb; I have noticed that > deleting messages form the e-mail clients and running tha dbmail-util > maintenance program deletes the messages from dbmail_messages but not > from dbmail_messageblks. Right now I have 24 records in the messages > table, 888 in the messageblks. Dbmail-util is run as suggested in the > INSTALL file: > > /usr/local/sbin/dbmail-util -cturpd -l 24h -qq > > Is this normal behavior? >
InooDB keeps track of all database transactions and therefor it can only grow and never shrink.... See http://dev.mysql.com/doc/mysql/en/InnoDB_overview.html for more information. So innodb isn't right for dbmail and this is normal behavior for innodb -- Met vriendelijke groet / With kind regards, H. van Wees --- The official Gentoo motto is, "If it moves, compile it."
