[Edit] I'm refuting that this:
> MySQL supports transactions, row level locking, nested SQL, and even replication
is relevant in the context of what he said.
Even your comment, stating that MySQL doesn't maintain statistics, it's totally wrong and easily checked with 5 seconds of Googling.
To your edit: The idea that a DBMS would support so many advanced features and do nested loop joins is laughably ridiculous.
Can you provide documentation on other join methods?
[0] - http://dev.mysql.com/doc/refman/5.6/en/explain-output.html
http://www.xaprb.com/blog/2013/10/01/mysql-isnt-limited-to-n...
It doesn't do hash joins which is the biggest limitation but MySQL is pretty good a joins and certainly was never bad enough to warrant it's reputation. It's toolbox is smaller than other RDBMS products but it's not empty.
Correct. MySQL is laughably ridiculous.