Hallo zusammen,
wir haben in unserem slow-query.log über das Wochenende ca. 60 Einträge der folgenden Art erhalten:
# Time: 130817 9:15:19
# User@Host: moodle[moodle] @ hrz-xxxx.hrz.uni-kassel.de [141.51.xxx.xxx]
# Query_time: 10.507756 Lock_time: 0.000111 Rows_sent: 0 Rows_examined: 5341759
SET timestamp=1376723719;
SELECT ue.userid, ue.enrolid, pue.pstatus
FROM mdl_user_enrolments ue
JOIN mdl_enrol e ON (e.id = ue.enrolid AND e.enrol = 'meta' )
JOIN (SELECT xpue.userid, xpe.courseid, MIN(xpue.status + xpe.status) AS pstatus
FROM mdl_user_enrolments xpue
JOIN mdl_enrol xpe ON (xpe.id = xpue.enrolid AND xpe.enrol <> 'meta' AND xpe.enrol IN ('manual','self','meta'))
GROUP BY xpue.userid, xpe.courseid
) pue ON (pue.courseid = e.customint1 AND pue.userid = ue.userid)
WHERE (pue.pstatus = 0 AND ue.status > 0) OR (pue.pstatus > 0 and ue.status = 0);
Kann mir jemand sagen was das soll und ob man das irgendwie optimieren kann?
Danke und Gruß
Wesley