10 questions on MySQL speed-up and optimizations

Jay Pipes, author of Pro MySQL, on his blog posts 10 questions and answers dealing with MySQL speed optimizations.

  1. Which will be faster out of these two queries - one with OR or one with IN?
  2. Where does MyISAM cache table records?
  3. Which will be faster out of queries with explicit INNER JOIN and implicit one?
  4. Is InnoDB faster/better than MyISAM?
  5. Is CHAR faster than VARCHAR?
  6. Is VARCHAR(80) faster than VARCHAR(255)?
  7. Are there performance issues when joining tables from different storage engines?
  8. If I change a derived table to a view, will performance increase?
  9. If I see Using temporary; Using filesort” in the Extra column of EXPLAIN output, does that mean a temporary table is created on disk?
  10. Is it possible to do a FULL OUTER JOIN in MySQL?
This entry was posted in Database, Web dev. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

One Comment on 10 questions on MySQL speed-up and optimizations

  1. Zobair
    Posted 3/13/2008 at 7:11 am | Permalink

    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?

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*