hi,
recently i have problem with my Moodle installation version 2.8. it seems that course overview plugin create slow query and given high cpu usage.
the query is
SELECT cm.id AS coursemodule, m.*, cw.section, cm.visible AS visible,
cm.groupmode, cm.groupingid
FROM mdl_course_modules cm, mdl_course_sections cw, mdl_modules md,
mdl_chat m
WHERE cm.course IN ('990','954','860','902','548','451') AND
cm.instance = m.id AND
cm.section = cw.id AND
md.name = 'chat' AND
md.id = cm.module
and much more.
anyone have been in this situation? before this it never give me any problem only after last night. Now i just turn of the blocks and disable it. But it's not the solution.
Anyone here can help?
Thanks