Hi all,
I just deleted 2 folders containing 70K mails, but the space isn't
recovered IMO.
When deleting the mails and run
dbmail-util -apdy
I can see the mails gets deleted. But when deleting the whole folder
then run
dbmail-util -apdy
I can't see 70K+ mails getting deleted/purged and from the free space of
innodb I also can't see more free space.
mailbox size for the users is
SELECT SUM( curmail_size ) FROM `dbmail_users`
696838846
innodb is 2G and free space is InnoDB free: 214016 kB
(was +/- the same before deletion)
# ls -l innodb01
-rw-rw---- 1 mysql mysql 2097152000 Apr 1 10:29 innodb01
I am using dbmail-2.0.9 on Linux with mysql *4.1.14.
Shouldn't everything be deleted by this foreign key constraint?
FOREIGN KEY mailbox_idnr_fk (mailbox_idnr)
REFERENCES dbmail_mailboxes (mailbox_idnr) ON DELETE
CASCADE ON
Any idea is welcome to recovered the lost space
Ming-Wei
*
