1.
Table Design and MySQL Index Details
Table design and MySQL index details. ... mysql> DESCRIBE hints .... Not surprising since there are no indexes MySQL can use (possible_keys: NULL). ...
2.
Indexing Basic MySQL Queries
mysql> EXPLAIN SELECT post_id FROM phpbb_posts WHERE topic_id=30 GROUP BY post_id; ... "Using temporary" means MySQL creates a temporary table (hopefully in ...
3.
Table Design and MySQL Index Details
We would like MySQL to use an index to find matching rows (avoid a table scan) but this won't be possible given the OR conditions. For it to be possible, ...
4.
How To Index For Joins With MySQL
Despite initially looking challenging, we saw that if you take it two tables at a time, and isolate and index what MySQL needs, indexing for joins isn't so ...
5.
MySQL ORDER BY With LIMIT and ANALYZE
Consider our query with just the ORDER BY condition: Either way it goes this causes MySQL to do a full table scan. MySQL could index scan and get every row ...
6.
Documents about MySQL query optimization
If you are serious about MySQL performance then you must be serious about query optimization. The following documents are detailed examples of optimizing ...
7.
MySQL DNS Details
If the reverse lookup succeeds MySQL goes onto the next step. .... After reverse and forward lookups complete successfully MySQL makes two additional checks ...
8.
MySQL DNS Details
How MySQL really uses DNS and handles slow or failing nameservers. ... If the reverse lookup succeeds MySQL goes onto the next step. If the reverse lookup ...
9.
MySQL Select and Sort Status Variables
Sort_merge_passes involves step two of the query-sort process. MySQL first tries to sort all the rows in memory, the allotment of which is control by the ...
10.
Table Design and MySQL Index Details
We would like MySQL to use an index to find matching rows (avoid a table scan) but this won't be possible given the OR conditions. For it to be possible, ...