Bernard Johnson wrote:
Has anyone seen this before? Any idea what triggers it? Is it a bug or
a database corruption?
What I see is that the server suddenly becomes very slow, and new lmtpd
imap, etc connections either don't get greetings or they are very slow.
Looking into the logs give a bunch of messages like deadlock.txt.
The server owner thinks that something is wrong on the server and
reboots it. On reboot, innodb wants to rollback - rollback.txt.
dbmail-2.2.1
mysql-4.1.20
I totally missed this in the log before. This seems to be what started
the mysql monitor output:
070102 4:41:02 InnoDB: WARNING: over 4 / 5 of the buffer pool is
occupied by
InnoDB: lock heaps or the adaptive hash index! Check that your
InnoDB: transactions do not set too many row locks.
InnoDB: Your buffer pool size is 8 MB. Maybe you should make
InnoDB: the buffer pool bigger?
InnoDB: Starting the InnoDB Monitor to print diagnostics, including
InnoDB: lock heap and hash index sizes.
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
