Hi Patrick,

I would run EXPLAIN of that SELECT query to see if some indexes got corrupted or not used in the DB. This is more likely to slow query down rather than dbmail.

Checking DBMAIL headervalues integrity...
DATE SERVERNAME dbmail-util[12351]: [0x93dc008] Warning:[db] log_query_time(+299): slow query [SELECT hv.id FROM dbmail_headervalue hv LEFT JOIN dbmail_header h ON hv.id = h.headervalue_id WHERE h.headervalue_id IS NULL] took [79.420] seconds


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

Reply via email to