Below is the result of explain (select hv.id from dbmail_headervalue hv left
join dbmail_header h on hv.id = h.headervalue_id where h.headervalue_id is
NULL);
id, select_type, table, type, possible_keys,
key, key_len, ref,
rows, Extra
'1', 'SIMPLE', 'hv', 'index',
NULL, 'datefield', '9',
NULL, '25544862', 'Using index'
'1', 'SIMPLE', 'h', 'ref',
'headervalue_id', 'headervalue_id', '8',
'dbmail.hv.id', '1', 'Using where;
Using index; Not exists'
I guess the NULLs look a bit suspicious.
Not really sure where to go from here.
Thanks for your help.
From: [email protected] [mailto:[email protected]] On Behalf Of
Gennadiy Poryev
Sent: Thursday, January 16, 2014 9:40 AM
To: DBMail mailinglist
Subject: Re: [Dbmail] Dbmail-util functionality problems
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
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
