I have loads of these in my slow query log and the box is suffering.
# Query_time: 75 Lock_time: 0 Rows_sent: 0 Rows_examined: 225432
SET timestamp=1187861236;
SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON
m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id
JOIN dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr=2
AND n.headername IN ('resent-message-id','message-id') AND
v.headervalue='<[EMAIL PROTECTED]>'AND
p.internal_date > NOW() - INTERVAL 3 DAY;
What client makes these and why etc?
Version 2.2.6-rc1, imapd+lmtpd only.
Thanks,
--
Aleksander Kamenik
system administrator
+372 6659 649
[EMAIL PROTECTED]
Krediidiinfo AS
http://www.krediidiinfo.ee/
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
