You aren't really an end-user, though. You're somewhere in the middle. This is a message from inside the mail system saying, "Hey, the client might be experiencing slowness, and this is a possible symptom, so the mail administrator is going to need to take a look at this."
You can adjust the query time escalation thresholds with the following dbmail.conf options that take integer arguments (number of seconds): [DBMAIL] query_time_info query_time_message query_time_warning These default to 10, 20, and 30 seconds, respectively. I think if you just raise the warning time you'll be fine. Aaron On Mon, 2007-07-23 at 15:00 +0200, Anne wrote: > We have this script running which calls dbmail-util. If a warning or > error occurs an email is sent. > Since 2.2.6 we get an email every day because of this query warning. > This is kind of annoying. > I'd strongly suggest you put this info under the verbose option. We > end-users can't do anything with that info, right? > > thanks, > Anne > > > I added query timing code to 2.2.6 so that we can find out which of our > > queries are still taking way too long. The longest default time is 30 > > seconds, which bumps the query up to the WARNING (level 2). > > > > Because this dbmail-util query is issued by the sysadmin it's not > > something we'd necessarily need to work about. > > > > Aaron > > > > On Mon, 2007-07-16 at 08:33 +0200, Anne wrote: > > > > > Running dbmail-util, I get this warning all the time: > > > > > > Checking DBMAIL for cached header values... > > > Jul 16 08:22:02 server.domain dbmail-util[15889]: Warning:[db] > > > dbmodule.c,db_query(+151): slow qu > > > ery [SELECT p.id FROM dbmail_physmessage p LEFT JOIN dbmail_headervalue > > > h ON p.id = h.physmessage_id > > > WHERE h.physmessage_id IS NULL] took [48] seconds > > > Ok. Found [0] un-cached physmessages. > > > > > > > > > > > > > -----BEGIN PGP SIGNED MESSAGE----- > > > > Hash: SHA1 > > > > > > > > > > > > hi all, > > > > > > > > I've uploaded v2.2.6-rc1 > > > > > > > > The main highlights: > > > > > > > > - - fixes an error in the imap code that was plaguing squirrelmail users > > > > - - support for imap IDLE > > > > - - adds support for duplicate suppression > > > > - - extends the capabilities of the dbmail-export tool > > > > > > > > download: > > > > > > > > http://www.dbmail.org/download/2.2/dbmail-2.2.6-rc1.tar.gz > > > > > > > > debs: > > > > > > > > deb http://debian.nfgd.net/debian stable main > > > > > > > > full changelog: > > > > > > > > http://nfg3.nfgs.net/cgi-bin/gitweb.cgi?p=dbmail.git;a=log;h=dbmail_2_2 > > > > > > > > - -- > > > > ________________________________________________________________ > > > > Paul Stevens paul at nfg.nl > > > > NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 > > > > The Netherlands________________________________http://www.nfg.nl > > > > -----BEGIN PGP SIGNATURE----- > > > > Version: GnuPG v1.4.6 (GNU/Linux) > > > > > > > > iD8DBQFGmNEG8iITvBH4zTERAo8QAJ9SqhiOYd5E1JrFPeTKsqzBnNGM3QCdHM6r > > > > siLNKkVRrhiT6fKrZlcZiZ8= > > > > =XpN6 > > > > -----END PGP SIGNATURE----- > > > > _______________________________________________ > > > > DBmail mailing list > > > > [email protected] > > > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > > > > > _______________________________________________ > > > DBmail mailing list > > > [email protected] > > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > _______________________________________________ > > DBmail mailing list > > [email protected] > > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
