Hello,
I am using moodle 1.9, and recently I have noticed many long running queries which appear to be coming from the gradebook.
mysql jumps up to 700+% processor when these queries are running. They never seen to finish, or are extremely inefficient (2000+ seconds). I have 15 processors and 16G of memory. It seems frozen on "copying to tmp table" as seen below. Has anyone seen this before? Eventually the site will become unusable.
11491 | admin | localhost | p_moodle |
Query | 1995 | Copying to tmp table | SELECT gi.id, COUNT(u.id) AS
count
FROM grade_items gi
11841 | admin | localhost | p_moodle |
Query | 1974 | Copying to tmp table | SELECT gi.id, COUNT(u.id) AS
count
FROM grade_items gi
12754 | admin | localhost | p_moodle |
Query | 1745 | Copying to tmp table | SELECT gi.id, COUNT(u.id) AS
count
FROM grade_items gi
12985 | admin | localhost | p_moodle |
Query | 1761 | Copying to tmp table | SELECT gi.id, COUNT(u.id) AS
count
FROM grade_items gi