Aleksander Kamenik wrote:
> 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?
This query comes from the suppress_duplicates code.
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
