Jay Pipes, author of Pro MySQL, on his blog posts 10 questions and answers dealing with MySQL speed optimizations.
- Which will be faster out of these two queries - one with OR or one with IN?
- Where does MyISAM cache table records?
- Which will be faster out of queries with explicit INNER JOIN and implicit one?
- Is InnoDB faster/better than MyISAM?
- Is CHAR faster than VARCHAR?
- Is VARCHAR(80) faster than VARCHAR(255)?
- Are there performance issues when joining tables from different storage engines?
- If I change a derived table to a view, will performance increase?
- If I see Using temporary; Using filesort” in the Extra column of EXPLAIN output, does that mean a temporary table is created on disk?
- Is it possible to do a FULL OUTER JOIN in MySQL?
One Comment on 10 questions on MySQL speed-up and optimizations
Which will be faster out of these two queries - one with OR or one with IN? Where does MyISAM cache table records? Which will be faster out of queries with explicit INNER JOIN and implicit one? Is InnoDB faster/better than MyISAM? Is CHAR faster than VARCHAR? Is VARCHAR(80) faster than VARCHAR(255)? Are there performance issues when joining tables from different storage engines? If I change a derived table to a view, will performance increase? If I see Using temporary; Using filesort†in the Extra column of EXPLAIN output, does that mean a temporary table is created on disk? Is it possible to do a FULL OUTER JOIN in MySQL?