Please ensure this page remains unpublished.<br><br>
<a href="http://dev.mysql.com/doc/refman/4.1/en/explain.html">Documentation on reading EXPLAIN statements.
</a><br><br>Running MySQL 4.0.25<br><br>
<b>EXPLAIN SELECT DISTINCT i.sid, i.type FROM search_index i INNER JOIN node n ON n.nid = i.sid INNER JOIN users u ON n.uid = u.uid WHERE n.status = 0 AND (i.word LIKE 'search')</b><br><br><table><tr><th>table</th><th>type</th><th>possible_keys</th><th>key</th><th>key_len</th><th>ref</th><th>rows</th><th>Extra</th></tr><tr><td>i</td><td>range</td><td>sid,word</td><td>word</td><td>50</td><td></td><td>4314</td><td>Using where; Using temporary</td></tr><tr><td>n</td><td>eq_ref</td><td>PRIMARY,uid,node_status_type</td><td>PRIMARY</td><td>4</td><td>i.sid</td><td>1</td><td>Using where; Distinct</td></tr><tr><td>u</td><td>eq_ref</td><td>PRIMARY</td><td>PRIMARY</td><td>4</td><td>n.uid</td><td>1</td><td>Using where; Using index; Distinct</td></tr></table><br><br><b>EXPLAIN SELECT i.type, i.sid, SUM(i.score/t.count) AS score FROM search_index i INNER JOIN node n ON n.nid = i.sid INNER JOIN users u ON n.uid = u.uid INNER JOIN search_total t ON i.word = t.word WHERE n.status = 0 AND (i.word LIKE 'search') GROUP BY i.type, i.sid ORDER BY score DESC LIMIT 0, 10</b><br><br><table><tr><th>table</th><th>type</th><th>possible_keys</th><th>key</th><th>key_len</th><th>ref</th><th>rows</th><th>Extra</th></tr><tr><td>i</td><td>range</td><td>sid,word</td><td>word</td><td>50</td><td></td><td>4314</td><td>Using where; Using temporary; Using filesort</td></tr><tr><td>n</td><td>eq_ref</td><td>PRIMARY,uid,node_status_type</td><td>PRIMARY</td><td>4</td><td>i.sid</td><td>1</td><td>Using where</td></tr><tr><td>u</td><td>eq_ref</td><td>PRIMARY</td><td>PRIMARY</td><td>4</td><td>n.uid</td><td>1</td><td>Using where; Using index</td></tr><tr><td>t</td><td>eq_ref</td><td>PRIMARY</td><td>PRIMARY</td><td>50</td><td>i.word</td><td>1</td><td></td></tr></table><br><br><b>EXPLAIN SELECT DISTINCT i.sid, i.type FROM search_index i INNER JOIN node n ON n.nid = i.sid INNER JOIN users u ON n.uid = u.uid WHERE n.status = 0 AND (i.word LIKE 'search1' OR i.word LIKE 'search2')</b><br><br><table><tr><th>table</th><th>type</th><th>possible_keys</th><th>key</th><th>key_len</th><th>ref</th><th>rows</th><th>Extra</th></tr><tr><td>i</td><td>range</td><td>sid,word</td><td>word</td><td>50</td><td></td><td>2</td><td>Using where; Using temporary</td></tr><tr><td>n</td><td>eq_ref</td><td>PRIMARY,uid,node_status_type</td><td>PRIMARY</td><td>4</td><td>i.sid</td><td>1</td><td>Using where; Distinct</td></tr><tr><td>u</td><td>eq_ref</td><td>PRIMARY</td><td>PRIMARY</td><td>4</td><td>n.uid</td><td>1</td><td>Using where; Using index; Distinct</td></tr></table><br><br><b>EXPLAIN SELECT i.type, i.sid, SUM(i.score/t.count) AS score FROM search_index i INNER JOIN node n ON n.nid = i.sid INNER JOIN users u ON n.uid = u.uid INNER JOIN search_total t ON i.word = t.word WHERE n.status = 0 AND (i.word LIKE 'search1' OR i.word LIKE 'search2') GROUP BY i.type, i.sid ORDER BY score DESC LIMIT 0, 10</b><br><br><table><tr><th>table</th><th>type</th><th>possible_keys</th><th>key</th><th>key_len</th><th>ref</th><th>rows</th><th>Extra</th></tr><tr><td>i</td><td>range</td><td>sid,word</td><td>word</td><td>50</td><td></td><td>2</td><td>Using where; Using temporary; Using filesort</td></tr><tr><td>n</td><td>eq_ref</td><td>PRIMARY,uid,node_status_type</td><td>PRIMARY</td><td>4</td><td>i.sid</td><td>1</td><td>Using where</td></tr><tr><td>u</td><td>eq_ref</td><td>PRIMARY</td><td>PRIMARY</td><td>4</td><td>n.uid</td><td>1</td><td>Using where; Using index</td></tr><tr><td>t</td><td>eq_ref</td><td>PRIMARY</td><td>PRIMARY</td><td>50</td><td>i.word</td><td>1</td><td></td></tr></table><br><br><b>EXPLAIN SELECT COUNT(a.uid) AS hits, a.uid, u.name, a.hostname, SUM(a.timer) AS total, ac.aid FROM accesslog a LEFT JOIN access ac ON ac.type = '0' AND LOWER(a.hostname) LIKE (ac.mask) LEFT JOIN users u ON a.uid = u.uid GROUP BY a.hostname ORDER BY hits DESC LIMIT 0, 10</b><br><br><table><tr><th>table</th><th>type</th><th>possible_keys</th><th>key</th><th>key_len</th><th>ref</th><th>rows</th><th>Extra</th></tr><tr><td>a</td><td>ALL</td><td></td><td></td><td></td><td></td><td>421049</td><td>Using temporary; Using filesort</td></tr><tr><td>ac</td><td>ALL</td><td></td><td></td><td></td><td></td><td>40</td><td></td></tr><tr><td>u</td><td>eq_ref</td><td>PRIMARY</td><td>PRIMARY</td><td>4</td><td>a.uid</td><td>1</td><td></td></tr></table><br><br><b>EXPLAIN SELECT DISTINCT(n.nid), n.title, n.type, n.changed, n.uid, u.name, l.last_comment_timestamp AS last_post, l.comment_count FROM node n INNER JOIN node_comment_statistics l ON n.nid = l.nid INNER JOIN users u ON n.uid = u.uid LEFT JOIN comments c ON n.nid = c.nid AND (c.status = 0 OR c.status IS NULL) WHERE n.status = 0 AND (n.uid = 0 OR c.uid = 0) ORDER BY last_post DESC LIMIT 0, 10</b><br><br><table><tr><th>table</th><th>type</th><th>possible_keys</th><th>key</th><th>key_len</th><th>ref</th><th>rows</th><th>Extra</th></tr><tr><td>n</td><td>ref</td><td>PRIMARY,uid,node_status_type</td><td>node_status_type</td><td>4</td><td>const</td><td>561</td><td>Using where; Using temporary; Using filesort</td></tr><tr><td>l</td><td>eq_ref</td><td>PRIMARY</td><td>PRIMARY</td><td>4</td><td>n.nid</td><td>1</td><td></td></tr><tr><td>u</td><td>eq_ref</td><td>PRIMARY</td><td>PRIMARY</td><td>4</td><td>n.uid</td><td>1</td><td>Using where</td></tr><tr><td>c</td><td>ref</td><td>lid</td><td>lid</td><td>4</td><td>n.nid</td><td>4</td><td>Using where; Distinct</td></tr></table><br><br><b>EXPLAIN SELECT DISTINCT i.sid, i.type FROM search_index i INNER JOIN node n ON n.nid = i.sid INNER JOIN users u ON n.uid = u.uid WHERE n.status = 0 AND (i.word LIKE 'search1' OR i.word LIKE 'search2' OR i.word LIKE 'search3')</b><br><br><table><tr><th>table</th><th>type</th><th>possible_keys</th><th>key</th><th>key_len</th><th>ref</th><th>rows</th><th>Extra</th></tr><tr><td>i</td><td>range</td><td>sid,word</td><td>word</td><td>50</td><td></td><td>3</td><td>Using where; Using temporary</td></tr><tr><td>n</td><td>eq_ref</td><td>PRIMARY,uid,node_status_type</td><td>PRIMARY</td><td>4</td><td>i.sid</td><td>1</td><td>Using where; Distinct</td></tr><tr><td>u</td><td>eq_ref</td><td>PRIMARY</td><td>PRIMARY</td><td>4</td><td>n.uid</td><td>1</td><td>Using where; Using index; Distinct</td></tr></table><br><br><b>EXPLAIN SELECT i.type, i.sid, SUM(i.score/t.count) AS score FROM search_index i INNER JOIN node n ON n.nid = i.sid INNER JOIN users u ON n.uid = u.uid INNER JOIN search_total t ON i.word = t.word WHERE n.status = 0 AND (i.word LIKE 'search1' OR i.word LIKE 'search2' OR i.word LIKE 'search3') GROUP BY i.type, i.sid ORDER BY score DESC LIMIT 0, 10</b><br><br><table><tr><th>table</th><th>type</th><th>possible_keys</th><th>key</th><th>key_len</th><th>ref</th><th>rows</th><th>Extra</th></tr><tr><td>i</td><td>range</td><td>sid,word</td><td>word</td><td>50</td><td></td><td>3</td><td>Using where; Using temporary; Using filesort</td></tr><tr><td>n</td><td>eq_ref</td><td>PRIMARY,uid,node_status_type</td><td>PRIMARY</td><td>4</td><td>i.sid</td><td>1</td><td>Using where</td></tr><tr><td>u</td><td>eq_ref</td><td>PRIMARY</td><td>PRIMARY</td><td>4</td><td>n.uid</td><td>1</td><td>Using where; Using index</td></tr><tr><td>t</td><td>eq_ref</td><td>PRIMARY</td><td>PRIMARY</td><td>50</td><td>i.word</td><td>1</td><td></td></tr></table><br><br><b>EXPLAIN SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '0' AND u.status < 1 LIMIT 0, 10</b><br><br><table><tr><th>Comment</th></tr><tr><td>Impossible WHERE noticed after reading const tables</td></tr></table><br><br><b>EXPLAIN SELECT DISTINCT m.*, r.*, u.name, u.uid FROM cvs_messages m INNER JOIN cvs_files f ON m.cid = f.cid INNER JOIN cvs_repositories r ON m.rid = r.rid INNER JOIN users u ON m.uid = u.uid ORDER BY m.created DESC LIMIT 0, 10</b><br><br><table><tr><th>table</th><th>type</th><th>possible_keys</th><th>key</th><th>key_len</th><th>ref</th><th>rows</th><th>Extra</th></tr><tr><td>m</td><td>ALL</td><td>PRIMARY,uid,cid,rid</td><td></td><td></td><td></td><td>24954</td><td>Using temporary; Using filesort</td></tr><tr><td>f</td><td>ref</td><td>cid</td><td>cid</td><td>4</td><td>m.cid</td><td>3</td><td>Using index</td></tr><tr><td>r</td><td>ALL</td><td>PRIMARY</td><td></td><td></td><td></td><td>2</td><td>Using where</td></tr><tr><td>u</td><td>eq_ref</td><td>PRIMARY</td><td>PRIMARY</td><td>4</td><td>m.uid</td><td>1</td><td></td></tr></table><br><br><b>EXPLAIN SELECT DISTINCT(n.nid), n.title, n.type, n.changed, n.uid, u.name, l.last_comment_timestamp AS last_post, l.comment_count FROM node n INNER JOIN users u ON n.uid = u.uid INNER JOIN node_comment_statistics l ON n.nid = l.nid WHERE n.status = 0 ORDER BY last_post DESC LIMIT 0, 10</b><br><br><table><tr><th>table</th><th>type</th><th>possible_keys</th><th>key</th><th>key_len</th><th>ref</th><th>rows</th><th>Extra</th></tr><tr><td>n</td><td>ref</td><td>PRIMARY,uid,node_status_type</td><td>node_status_type</td><td>4</td><td>const</td><td>561</td><td>Using where; Using temporary; Using filesort</td></tr><tr><td>u</td><td>eq_ref</td><td>PRIMARY</td><td>PRIMARY</td><td>4</td><td>n.uid</td><td>1</td><td>Using where</td></tr><tr><td>l</td><td>eq_ref</td><td>PRIMARY</td><td>PRIMARY</td><td>4</td><td>n.nid</td><td>1</td><td></td></tr></table><br><br><b>EXPLAIN SELECT COUNT(a.uid) AS hits, a.uid, u.name, a.hostname, SUM(a.timer) AS total, ac.aid FROM accesslog a LEFT JOIN access ac ON ac.type = '0' AND LOWER(a.hostname) LIKE (ac.mask) LEFT JOIN users u ON a.uid = u.uid GROUP BY a.hostname ORDER BY total DESC LIMIT 0, 10</b><br><br><table><tr><th>table</th><th>type</th><th>possible_keys</th><th>key</th><th>key_len</th><th>ref</th><th>rows</th><th>Extra</th></tr><tr><td>a</td><td>ALL</td><td></td><td></td><td></td><td></td><td>421049</td><td>Using temporary; Using filesort</td></tr><tr><td>ac</td><td>ALL</td><td></td><td></td><td></td><td></td><td>40</td><td></td></tr><tr><td>u</td><td>eq_ref</td><td>PRIMARY</td><td>PRIMARY</td><td>4</td><td>a.uid</td><td>1</td><td></td></tr></table><br><br><b>EXPLAIN SELECT COUNT(DISTINCT(n.nid)) FROM node n LEFT JOIN comments c ON n.nid = c.nid AND (c.status = 0 OR c.status IS NULL) WHERE n.status = 0 AND (n.uid = 1 OR c.uid = 1)</b><br><br><table><tr><th>table</th><th>type</th><th>possible_keys</th><th>key</th><th>key_len</th><th>ref</th><th>rows</th><th>Extra</th></tr><tr><td>n</td><td>ref</td><td>uid,node_status_type</td><td>node_status_type</td><td>4</td><td>const</td><td>561</td><td>Using where</td></tr><tr><td>c</td><td>ref</td><td>lid</td><td>lid</td><td>4</td><td>n.nid</td><td>4</td><td>Using where</td></tr></table><br><br> </div>