blog’s amazing Rotating Header Image

MySQL – limitations you never heard of

We all know MySQL has its limits – it works fine in general, but has its weaknesses too. The authors of MySQL Performance blog started a miniseries about such limitations for experienced users. Okay, I guess you know there’s no way to create fulltext index on InnoDB tables – but bid you know, that MySQL may rewrite your subqueries to do full table scans instead? If not, make sure to follow the series:

http://www.mysqlperformanceblog.com/2010/10/25/mysql-limitations-part-3-subqueries/

Bookmark and Share

One Comment

  1. Slava says:

    Another aspect is that the result order is undefined—although the example above produces the numbers is ascending order. That’s just because the way MySQL joins the two views. If you build another meta view, e.g.,

Leave a Reply