I looked at my production dbmail and the current message_idnr in my dbmail_messages table is almost at 65.000.000. And there are many other tables with very high auto increment values, i.e. the dbmail_headervalue which is at an index of almost 202.000.000.
Op 7 jul 2010, om 00:06 heeft N Sj het volgende geschreven: > After some more digging, I think the problem might be reproduced by following > these steps: > > 1. Create a new database and table structure for dbmail. > 2. create a test user - [email protected] > 3. Alter table "dbmail_messages" to start message_idnr from a high number. > ALTER TABLE dbmail_messages auto_increment = 99999999; > 4. send 30 to 40 test messages to the [email protected] mailbox and then test > imap. > > Now dbmail-imapd will cause 100% (or high) CPU and show a delay while running > SEARCH and SORT commands. I hope this helps in further narrowing down the > problem. > > I have a lots of users and emails in the production database and the > message_idnr is very high, could this be causing a bottleneck in dbmail-imapd? > > > _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
