Aleksander Kamenik wrote:
I today installed dbmail-2.2.6-rc1 with the fix for bug 624 and the copylogs patch. Attaching both for convenience.

You upgraded from what version?


I'm suddenly and immediately after the install experiencing high load ( <0.5 versus 2-8 ) and doubled cpu user usage ( avg 10% versus avg 40% ) also softirq is about 8% now, whereas it was very near zero before.

What's going on? There are some slow queries too. The mysql slow query log is useless as it doesn't have a timestamp. There are some from maillog:

Jul 20 15:05:48 mail dbmail/imap4d[10544]: Message:[db] dbmodule.c,db_query(+149): slow query [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=581 AND (status < 2) UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=581 AND (status < 2) AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr=581 AND (status < 2) AND recent_flag=1] took [21] seconds

This query has been in place like this for quite some time now.

Jul 20 15:07:15 mail dbmail/imap4d[10544]: Message:[db] dbmodule.c,db_query(+149): slow query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag, DATE_FORMAT(internal_date, '%Y-%m-%d %T'), rfcsize, message_idnr FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr BETWEEN 1303615 AND 2660121 AND mailbox_idnr = 581 AND status IN (0,1,2) ORDER BY message_idnr ASC] took [32] seconds

Same here.

These might be causing the load or they are caused by the load. I have no idea. Some 25 IMAP users might be active now, not much more.

I can't tell what's going on based on this data. Gimme more.


--
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev

Reply via email to