On 02/01/2012 07:04 PM, Reindl Harald wrote:
> uhm this query is a killer!
>
> happens after first horde-wbemail login on the snapshoted test-machine
> with full transition done in offline mode
>
> better said: it happens while the first login because timeout finally
>
> (around 67.000 messages with 10 GB)
> __________________________
>
> | 135 | dbmail | localhost | dbmail | Execute | 453 | Copying to tmp table |
> SELECT DISTINCT m.message_idnr FROM
> dbmail_mimeparts k LEFT JOIN dbmail_partlists l ON k.id=l.part_i
That query looks truncated. Could you please fetch the full query and
run it with 'explain'?
Actually, if you use file_logging_level=511 you can obtain both the full
query and the IMAP command that triggers it.
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
* Premium Hosting Services and Web Application Consultancy *
www.nfg.nl/[email protected]/+31.85.877.99.97
________________________________________________________________
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
