What's the time specified in the warning message? On Mon, 2007-07-23 at 17:03 +0200, Anne wrote: > I put query_time_warning = 500 in dbmail.conf under the DBMAIL > section. > dbmail-util still gives me a warning. Do I need to restart anything? > > thanks, > Anne > > > 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 > > > > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
