Mailing List Archive: Sending mail slowly

Sending mail slowly

Oct 14, 2014, 10:42 PM

Post #1 of 4 (1515 views)

Hello,

I use dbmail 2.2.18.

I found this in maillog:

Oct 15 07:34:15 xxx dbmail/imap4d[9461]: Message:[db] dbmodule.c,db_query(+149): slow query [.SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessag
e_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE mailbox_idnr = 3047 AND status IN (0,1) AND headername LIKE 'MESSAGE-ID' AND headervalue LIKE '%<''da5c65a8e90626e027641f97fe43b421@YYYYYY.eu ' '%'
ORDER BY message_idnr] took [24] seconds

Is this a true problem? What can I do? Sending mails is sometimes very slowly.

Ralph
--
Mit freundlichen GrÃ¼ÃŸen
Ralph Ballier

Re: Sending mail slowly [ In reply to ]

lordvan at lordvan

Oct 15, 2014, 4:21 AM

Post #2 of 4 (1501 views)

Permalink

On 2014-10-15 07:42, Ralph Ballier wrote:
> Hello,
>
> I use dbmail 2.2.18.
>
> I found this in maillog:
>
> Oct 15 07:34:15 xxx dbmail/imap4d[9461]: Message:[db]
> dbmodule.c,db_query(+149): slow query [.SELECT message_idnr FROM
> dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id
> JOIN dbmail_headervalue v ON v.physmessag
> e_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE
> mailbox_idnr = 3047 AND status IN (0,1) AND headername LIKE
> 'MESSAGE-ID' AND headervalue LIKE
> '%<da5c65a8e90626e027641f97fe43b421@YYYYYY.eu>%'
> ORDER BY message_idnr] took [24] seconds
>
> Is this a true problem? What can I do? Sending mails is sometimes
> very slowly.
>

Hi.

Apart from if it is a problem or not ... this has nothing to do with
sending mail. This seems to be an IMAP searchfor a certain MESSAGE-ID
(maybe to set a flag or something after sending) ?

Regards
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: Sending mail slowly [ In reply to ]

ba at osz-lise-meitner

Oct 16, 2014, 11:19 AM

Post #3 of 4 (1496 views)

Permalink

I have this command executed directly in the database. He referred to the mailbox "sent". This 120,000 lines were displayed. That's why it took so long apparently. I then set up a new mailbox for "sent". Now lasts 3 seconds to send.

Ralph

----------------ursprÃ¼ngliche Nachricht-----------------
Von: Thomas Raschbacher [''lordvan@lordvan.com ' ']
An: DBMail mailinglist [''dbmail@dbmail.org ' ']
Datum: Wed, 15 Oct 2014 13:21:54 +0200
-------------------------------------------------

> On 2014-10-15 07:42, Ralph Ballier wrote:
>> Hello,
>>
>> I use dbmail 2.2.18.
>>
>> I found this in maillog:
>>
>> Oct 15 07:34:15 xxx dbmail/imap4d[9461]: Message:[db]
>> dbmodule.c,db_query(+149): slow query [.SELECT message_idnr FROM
>> dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id
>> JOIN dbmail_headervalue v ON v.physmessag
>> e_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE
>> mailbox_idnr = 3047 AND status IN (0,1) AND headername LIKE
>> 'MESSAGE-ID' AND headervalue LIKE
>> '%<''da5c65a8e90626e027641f97fe43b421@YYYYYY.eu ' '%'
>> ORDER BY message_idnr] took [24] seconds
>>
>> Is this a true problem? What can I do? Sending mails is sometimes
>> very slowly.
>>
>
> Hi.
>
> Apart from if it is a problem or not ... this has nothing to do with
> sending mail. This seems to be an IMAP searchfor a certain MESSAGE-ID
> (maybe to set a flag or something after sending) ?
>
> Regards
> _______________________________________________
> DBmail mailing list
> ''DBmail@dbmail.org ' ' http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
>
>
</span>
--
Mit freundlichen GrÃ¼ÃŸen
Ralph Ballier

_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: Sending mail slowly [ In reply to ]

paul at nfg

Oct 25, 2014, 2:43 AM

Post #4 of 4 (1489 views)

Permalink

disable suppress_duplicates. That's what's triggering the query.

On 10/16/2014 08:19 PM, Ralph Ballier wrote:
> I have this command executed directly in the database. He referred to the mailbox "sent". This 120,000 lines were displayed. That's why it took so long apparently. I then set up a new mailbox for "sent". Now lasts 3 seconds to send.
>
> Ralph
>
> ----------------ursprÃ¼ngliche Nachricht-----------------
> Von: Thomas Raschbacher [''lordvan@lordvan.com ' ']
> An: DBMail mailinglist [''dbmail@dbmail.org ' ']
> Datum: Wed, 15 Oct 2014 13:21:54 +0200
> -------------------------------------------------
>
>
>> On 2014-10-15 07:42, Ralph Ballier wrote:
>>> Hello,
>>>
>>> I use dbmail 2.2.18.
>>>
>>> I found this in maillog:
>>>
>>> Oct 15 07:34:15 xxx dbmail/imap4d[9461]: Message:[db]
>>> dbmodule.c,db_query(+149): slow query [.SELECT message_idnr FROM
>>> dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id
>>> JOIN dbmail_headervalue v ON v.physmessag
>>> e_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE
>>> mailbox_idnr = 3047 AND status IN (0,1) AND headername LIKE
>>> 'MESSAGE-ID' AND headervalue LIKE
>>> '%<''da5c65a8e90626e027641f97fe43b421@YYYYYY.eu ' '%'
>>> ORDER BY message_idnr] took [24] seconds
>>>
>>> Is this a true problem? What can I do? Sending mails is sometimes
>>> very slowly.
>>>
>>
>> Hi.
>>
>> Apart from if it is a problem or not ... this has nothing to do with
>> sending mail. This seems to be an IMAP searchfor a certain MESSAGE-ID
>> (maybe to set a flag or something after sending) ?
>>
>> Regards
>> _______________________________________________
>> DBmail mailing list
>> ''DBmail@dbmail.org ' ' http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
>>
>>
> </span>
>

--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
www.nfg.nl/info@nfg.nl/+31.85.877.99.97
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail