So what Huib van Wees is saying is, you can't delete records in an innodb table.
This is absolutely not true. Nor does it make sense. Perhaps a translation issue? Innodb works rather well for me, but I'm on a 1.x version, so I can't help you here, sorry. If this is repeatable, I'd file a bug report, you'd get faster service I bet by the developers. -Micah On Saturday 27 November 2004 06:38 pm, Huib van Wees wrote: > 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
