Hi,
my database holding the reputation database grows drastic.
since some days opendkim-genstats does not work anymore.
opendkim-genstats: started at Mon Jun 11 14:12:41 2012
opendkim-genstats: connected to database
opendkim-genstats: report started in /repute/htdocs/report/index.html.15204
opendkim-genstats: constructing temporary table
opendkim-genstats: populating temporary table
opendkim-genstats: INSERT INTO TEMPORARY TABLE failed: The total number of locks exceeds the lock
table size
mysql error.log ends with:
<huge section with INNODB MONITOR OUTPUT>
120611 14:17:16 InnoDB: WARNING: over 67 percent 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.
120611 14:17:16 InnoDB: WARNING: over 67 percent 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.
any suggestions to a nonmysql-profi?
--
Viele Grüße
Andreas Schulze
Received on Mon Jun 11 2012 - 12:42:31 PST