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