https://docs.moodle.org/23/en/index.php?title=Performance_testing_moodle.org_details&feed=atom&action=history
Performance testing moodle.org details - Revision history
2024-03-29T14:21:18Z
Revision history for this page on the wiki
MediaWiki 1.39.6
https://docs.moodle.org/23/en/index.php?title=Performance_testing_moodle.org_details&diff=63500&oldid=prev
Fox: Category:Moodle.org
2009-09-24T07:56:13Z
<p>Category:Moodle.org</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 07:56, 24 September 2009</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l459">Line 459:</td>
<td colspan="2" class="diff-lineno">Line 459:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> AND r.hidden = 0 ORDER BY lastaccess DESC, r.hidden DESC LIMIT 20</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div> AND r.hidden = 0 ORDER BY lastaccess DESC, r.hidden DESC LIMIT 20</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></pre></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[Category:Moodle.org]]</ins></div></td></tr>
</table>
Fox
https://docs.moodle.org/23/en/index.php?title=Performance_testing_moodle.org_details&diff=52043&oldid=prev
Dougiamas at 06:52, 5 March 2009
2009-03-05T06:52:53Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 06:52, 5 March 2009</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">__TOC__</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==slowtest==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==slowtest==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
</table>
Dougiamas
https://docs.moodle.org/23/en/index.php?title=Performance_testing_moodle.org_details&diff=52042&oldid=prev
Dougiamas at 06:50, 5 March 2009
2009-03-05T06:50:57Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 06:50, 5 March 2009</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>== slowtest <del style="font-weight: bold; text-decoration: none;">on new servers </del>with innodb (before cache) ==</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>==slowtest<ins style="font-weight: bold; text-decoration: none;">==</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">=== </ins>with innodb (before cache) <ins style="font-weight: bold; text-decoration: none;">=</ins>==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><pre></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><pre></div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l229">Line 229:</td>
<td colspan="2" class="diff-lineno">Line 231:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>== <del style="font-weight: bold; text-decoration: none;">slowtest on new servers </del>with innodb (after cache) ==</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>==<ins style="font-weight: bold; text-decoration: none;">=</ins>with innodb (after cache)<ins style="font-weight: bold; text-decoration: none;">=</ins>==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><pre></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><pre></div></td></tr>
</table>
Dougiamas
https://docs.moodle.org/23/en/index.php?title=Performance_testing_moodle.org_details&diff=52041&oldid=prev
Dougiamas: /* slowtest on new servers with innodb */
2009-03-05T06:49:25Z
<p><span dir="auto"><span class="autocomment">slowtest on new servers with innodb</span></span></p>
<a href="https://docs.moodle.org/23/en/index.php?title=Performance_testing_moodle.org_details&diff=52041&oldid=52040">Show changes</a>
Dougiamas
https://docs.moodle.org/23/en/index.php?title=Performance_testing_moodle.org_details&diff=52040&oldid=prev
Dougiamas: New page: == slowtest on new servers with innodb == <pre> 25 slowest queries in moodle.org ......................... 1 iterations of query 0: total time 0.030494928359985 seconds (avg. 0.030494928...
2009-03-05T06:44:42Z
<p>New page: == slowtest on new servers with innodb == <pre> 25 slowest queries in moodle.org ......................... 1 iterations of query 0: total time 0.030494928359985 seconds (avg. 0.030494928...</p>
<p><b>New page</b></p><div>== slowtest on new servers with innodb ==<br />
<br />
<pre><br />
<br />
25 slowest queries in moodle.org<br />
.........................<br />
1 iterations of query 0: total time 0.030494928359985 seconds (avg. 0.030494928359985 seconds)<br />
1 iterations of query 1: total time 42.183392047882 seconds (avg. 42.183392047882 seconds)<br />
1 iterations of query 2: total time 1.9312369823456 seconds (avg. 1.9312369823456 seconds)<br />
1 iterations of query 3: total time 51.22772693634 seconds (avg. 51.22772693634 seconds)<br />
1 iterations of query 4: total time 1.1148638725281 seconds (avg. 1.1148638725281 seconds)<br />
1 iterations of query 5: total time 1.6617360115051 seconds (avg. 1.6617360115051 seconds)<br />
1 iterations of query 6: total time 23.254682064056 seconds (avg. 23.254682064056 seconds)<br />
1 iterations of query 7: total time 7.9712381362915 seconds (avg. 7.9712381362915 seconds)<br />
1 iterations of query 8: total time 0.015857934951782 seconds (avg. 0.015857934951782 seconds)<br />
1 iterations of query 9: total time 0.30761003494263 seconds (avg. 0.30761003494263 seconds)<br />
1 iterations of query 10: total time 0.16587519645691 seconds (avg. 0.16587519645691 seconds)<br />
1 iterations of query 11: total time 0.00037288665771484 seconds (avg. 0.00037288665771484 seconds)<br />
1 iterations of query 12: total time 0.25178194046021 seconds (avg. 0.25178194046021 seconds)<br />
1 iterations of query 13: total time 0.00029802322387695 seconds (avg. 0.00029802322387695 seconds)<br />
1 iterations of query 14: total time 0.00024104118347168 seconds (avg. 0.00024104118347168 seconds)<br />
1 iterations of query 15: total time 0.078457117080688 seconds (avg. 0.078457117080688 seconds)<br />
1 iterations of query 16: total time 4.0515379905701 seconds (avg. 4.0515379905701 seconds)<br />
1 iterations of query 17: total time 0.0073158740997314 seconds (avg. 0.0073158740997314 seconds)<br />
1 iterations of query 18: total time 2.0450401306152 seconds (avg. 2.0450401306152 seconds)<br />
1 iterations of query 19: total time 0.027537107467651 seconds (avg. 0.027537107467651 seconds)<br />
1 iterations of query 20: total time 1.1157040596008 seconds (avg. 1.1157040596008 seconds)<br />
1 iterations of query 21: total time 0.078656196594238 seconds (avg. 0.078656196594238 seconds)<br />
1 iterations of query 22: total time 3.5041410923004 seconds (avg. 3.5041410923004 seconds)<br />
1 iterations of query 23: total time 0.73689198493958 seconds (avg. 0.73689198493958 seconds)<br />
1 iterations of query 24: total time 2.2039468288422 seconds (avg. 2.2039468288422 seconds)<br />
<br />
TOTAL: 1 iterations of 25 queries: total time 143.9666364193 seconds (avg. 5.7586654567719 seconds)<br />
<br />
<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 0:<br />
DELETE FROM cache_text WHERE timemodified < '1234354127'<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 1:<br />
SELECT f.id, COUNT(p.id) AS unread<br />
FROM forum_posts p<br />
JOIN forum_discussions d ON d.id = p.discussion<br />
JOIN forum f ON f.id = d.forum<br />
JOIN course c ON c.id = f.course<br />
LEFT JOIN forum_read r ON (r.postid = p.id AND r.userid = 716)<br />
LEFT JOIN forum_track_prefs tf ON (tf.userid = 716 AND tf.forumid = f.id)<br />
WHERE f.course = 11<br />
AND p.modified >= 1233273900 AND r.id is NULL<br />
AND (f.trackingtype = 2<br />
OR (f.trackingtype = 1 AND tf.id IS NULL))<br />
GROUP BY f.id<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 2:<br />
SELECT p.id, p.subject, p.modified, p.discussion, p.userid, d.name,<br />
d.timemodified, d.usermodified, d.groupid, (COUNT(p.id) - 1) AS replies<br />
FROM forum_posts p<br />
, forum_discussions d <br />
WHERE d.course = 11<br />
AND d.id = p.discussion <br />
AND d.userid <> 153 AND p.modified >= '1234138176'<br />
GROUP BY p.discussion<br />
ORDER BY replies ASC<br />
,p.modified ASC<br />
LIMIT 2<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 3:<br />
SELECT p.*,<br />
d.forum,<br />
u.firstname,<br />
u.lastname,<br />
u.email,<br />
u.picture,<br />
u.imagealt<br />
FROM forum_posts p,<br />
forum_discussions d,<br />
user u<br />
WHERE (p.modified >= 665341500)<br />
AND p.discussion = d.id<br />
AND p.userid = u.id<br />
AND ((d.forum IN (15,32,931,485,94,1048,117,118,119,587,1001,116,126,337,333,121,122,365,123,366,124,128,396,441,345,678,512,397,320,224,476,130,967,941,1010,323,25,27,125,466,1006,141,140,999,603,1013,1023,1007,120,1022,1028,962,469,1000,1012,132,811,30,1024,1003,352,947,954,29,24,114,480,127,731,33,34,26,28,142,820,1027,827,965,994,998,1002)))<br />
ORDER BY p.modified DESC LIMIT 307670,10<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 4:<br />
SELECT * FROM (SELECT p.discussion, (COUNT(p.id) - 1) AS replies, MAX(p.id) AS lastpostid<br />
FROM forum_posts p<br />
JOIN forum_discussions d ON p.discussion = d.id<br />
WHERE d.forum = 15<br />
GROUP BY p.discussion , d.timemodified <br />
ORDER BY d.timemodified DESC) sq LIMIT 900,100<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 5:<br />
SELECT d.forum,d.course,COUNT(p.id) AS count FROM forum_posts p JOIN forum_discussions d ON p.discussion = d.id LEFT JOIN forum_read r ON r.postid = p.id AND r.userid = 32175 WHERE ((d.forum = 15 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 32 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 931 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 485 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 94 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 1048 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 117 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 118 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 119 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 587 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 1001 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 116 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 126 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 337 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 333 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 121 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 122 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 365 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 123 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 366 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 124 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 128 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 396 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 441 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 345 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 678 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 512 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 397 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 320 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 224 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 476 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 130 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 967 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 941 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 1010 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 323 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 25 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 27 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 125 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 466 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 1006 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 141 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 140 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 999 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 603 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 1013 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 1023 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 1007 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 120 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 1022 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 1028 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 962 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 469 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 1000 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 1012 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 132 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 811 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 30 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 1024 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 1003 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 352 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 947 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 954 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 29 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 24 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 114 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 480 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 127 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 731 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 33 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 34 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 26 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 28 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 142 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 820 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 1027 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 827 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 965 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 994 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 998 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 934 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 602 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 800 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 302 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 279 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 271 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 270 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 272 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 275 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 596 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 310 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 538 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 276 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 304 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 356 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 535 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 586 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 277 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 278 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 497 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 543 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 590 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 292 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 293 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 630 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 269 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 266 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 340 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 905 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 806 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 170 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 925 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 342 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 959 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 1016 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 981 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 896 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) OR (d.forum = 777 AND (d.groupid = -1 OR d.groupid = 0 OR d.groupid = 0)) ) AND p.modified >= 1233274139 AND r.id is NULL GROUP BY d.forum,d.course<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 6:<br />
SELECT l.*, u.firstname, u.lastname, u.picture<br />
FROM log l LEFT JOIN user u ON l.userid = u.id WHERE l.course='5' AND l.userid = '153' ORDER BY l.time DESC LIMIT 1297000,100<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 7:<br />
SELECT l.*, u.firstname, u.lastname, u.picture<br />
FROM log l LEFT JOIN user u ON l.userid = u.id WHERE l.course='5' AND l.userid = '153' ORDER BY l.time DESC LIMIT 1077500,100<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 8:<br />
DELETE FROM log WHERE time < '1231347952'<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 9:<br />
SELECT p.id AS postid,<br />
d.id AS discussionid,<br />
d.name AS discussionname,<br />
u.id AS userid,<br />
u.firstname AS userfirstname,<br />
u.lastname AS userlastname,<br />
p.subject AS postsubject,<br />
p.message AS postmessage,<br />
p.created AS postcreated,<br />
p.format AS postformat<br />
FROM forum_discussions d,<br />
forum_posts p,<br />
user u<br />
WHERE d.forum = '32' AND<br />
p.discussion = d.id AND<br />
u.id = p.userid AND p.modified > '1234308778'<br />
ORDER BY p.created desc LIMIT 10<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 10:<br />
SELECT instance,cmid,l.course,COUNT(l.id) as count FROM log l JOIN course_modules cm ON cm.id = cmid WHERE ((l.course = 5 AND l.time > 1234242461) ) AND l.module = 'forum' AND action LIKE 'add post%' AND userid != 638275 GROUP BY cmid,l.course,instance<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 11:<br />
SELECT * FROM cache_text WHERE md5key = 'f6dc0402d19753e135960ec40dfa7128' LIMIT 1<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 12:<br />
SELECT * FROM message_read WHERE (useridto = '128371' AND useridfrom = '114402') OR<br />
(useridto = '114402' AND useridfrom = '128371') ORDER BY timecreated<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 13:<br />
SELECT COUNT(*)<br />
FROM forum_posts p,<br />
forum_discussions d,<br />
user u<br />
WHERE MATCH (p.message, p.subject) AGAINST ('+no* +permite* +que* +entre* +nadie*' IN BOOLEAN MODE)<br />
AND p.discussion = d.id<br />
AND p.userid = u.id<br />
AND ((d.forum IN (100,103,102,513,625,883,955,988,714,104,106,107,108,109,110,111,112,351,338)))<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 14:<br />
SELECT p.*,<br />
d.forum,<br />
u.firstname,<br />
u.lastname,<br />
u.email,<br />
u.picture,<br />
u.imagealt<br />
FROM forum_posts p, forum_discussions d,<br />
user u<br />
WHERE MATCH (p.message, p.subject) AGAINST ('+tex*' IN BOOLEAN MODE)<br />
AND p.discussion = d.id<br />
AND p.userid = u.id<br />
AND ((d.forum IN (15,32,931,485,94,1048,117,118,119,587,1001,116,126,337,333,121,122,365,123,366,124,128,396,441,345,678,512,397,320,224,476,130,967,941,1010,323,25,27,125,466,1006,141,140,999,603,1013,1023,1007,120,102<br />
2,1028,962,469,1000,1012,132,811,30,1024,1003,352,947,954,29,24,114,480,127,731,33,34,26,28,142,820,1027,827,965,994,998,1002)))<br />
ORDER BY p.modified DESC LIMIT 21990,10<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 15:<br />
SELECT instance,cmid,l.course,COUNT(l.id) as count FROM log l JOIN course_modules cm ON cm.id = cmid WHERE ((l.course = 5 AND l.time > 1234335323) OR (l.course = 55 AND l.time > 1234102485) OR (l.course = 33 AND l.time > 1234102459) OR (l.course = 32 AND l.time > 1234266018) OR (l.course = 31 AND l.time > 1234102468) OR (l.course = 48 AND l.time > 1234347206) OR (l.course = 18 AND l.time > 1234301428) ) AND l.module = 'forum' AND action LIKE 'add post%' AND userid != 5382 GROUP BY cmid,l.course,instance<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 16:<br />
SELECT * FROM log WHERE userid='153' AND module='resource'<br />
AND action='view' AND info='273' ORDER BY time ASC<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 17:<br />
INSERT INTO log (time, userid, course, ip, module, cmid, action, url, info)<br />
VALUES ('1234467474', '153', '1', '190.128.3.65', 'user', '0', 'login', 'view.php?id=0&course=1', '153')<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 18:<br />
SELECT COUNT(*) FROM user WHERE firstaccess > 1234224195<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 19:<br />
SELECT l.*, cm.instance FROM log l <br />
INNER JOIN course_modules cm ON l.cmid = cm.id <br />
WHERE l.time > '1234199200' AND l.course = 11 <br />
AND l.module = 'wiki' AND action LIKE 'edit%'<br />
ORDER BY l.time ASC<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 20:<br />
DELETE<br />
FROM forum_read<br />
WHERE postid IN (SELECT fp.id<br />
FROM forum_posts fp<br />
WHERE fp.modified >= 1233011222 AND fp.modified < 1233099102)<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 21:<br />
SELECT * FROM event WHERE (timestart >= 1234386000 OR timestart + timeduration > 1234386000) AND timestart <= 1249937999 AND ( (userid = 794412 AND courseid = 0 AND groupid = 0) OR (groupid = 0 AND courseid IN (1))) AND visible = 1 ORDER BY timestart<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 22:<br />
SELECT floor((time - 1231340400)/86400) as day, count(*) as num<br />
FROM log<br />
WHERE userid = '153'<br />
AND time > '1231340400' AND course = '5' <br />
GROUP BY floor((time - 1231340400)/86400)<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 23:<br />
SELECT u.id, u.username, u.firstname, u.lastname, u.picture, max(ul.timeaccess) as lastaccess FROM user_lastaccess ul,<br />
user u<br />
, role_assignments ra WHERE ul.timeaccess > 1234409700<br />
AND u.id = ul.userid<br />
AND ul.courseid = 5<br />
AND ra.userid = u.id AND ra.contextid IN (53,54,50) AND ra.hidden = 0 GROUP BY u.id, u.username, u.firstname, u.lastname, u.picture ORDER BY lastaccess DESC LIMIT 50<br />
---------- ---------- ---------- ---------- ---------- ----------<br />
QUERY 24:<br />
SELECT DISTINCT u.id, u.username, u.firstname, u.lastname,<br />
u.email, u.city, u.country, u.picture,<br />
u.lang, u.timezone, u.emailstop, u.maildisplay, u.imagealt,<br />
COALESCE(ul.timeaccess, 0) AS lastaccess,<br />
r.hidden,<br />
ctx.id AS ctxid, ctx.path AS ctxpath,<br />
ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel FROM user u<br />
LEFT OUTER JOIN context ctx<br />
ON (u.id=ctx.instanceid AND ctx.contextlevel = 30)<br />
JOIN role_assignments r<br />
ON u.id=r.userid<br />
LEFT OUTER JOIN user_lastaccess ul<br />
ON (r.userid=ul.userid and ul.courseid = 11) WHERE (r.contextid = 74 OR r.contextid in (63,50))<br />
AND u.deleted = 0 <br />
AND (ul.courseid = 11 OR ul.courseid IS NULL)<br />
AND u.username != 'guest'<br />
AND r.roleid NOT IN (1,8,9)<br />
AND r.hidden = 0 ORDER BY lastaccess DESC, r.hidden DESC LIMIT 20<br />
<br />
</pre></div>
Dougiamas