Am 01.02.2012 20:57, schrieb Paul J Stevens: > 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.
sorry for the dumb question but how can i get the untruncated? this is from "show processlist" and had also the feeling that it may be truncated but phpMyAdmin showed the same "part_i" should be "part_id" -> C&P mistake hopefully i have later at night or tomorrow energy/time to switch the snapshot for analyze, currently the VM is running again as replication/backup-slave - i love VMware :-)
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
