On 02.02.2012 00:06, Reindl Harald wrote:
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
Via ssh it is:
# mysql -e "show full processlist"
or, as Paul said - just set log level to 511.
"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 :-)
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
