MySQL limitations

When using MySQL 5.1 Enterprise after years of using other database products like Sybase, Infomix, DB2; I run into things that MySQL just doesn't do. For example, it can only generate an EXPLAIN query plan for SELECT queries.

What other things I should watch out for?

Does MySQL have a size limit?

You are using a MyISAM table and the space required for the table exceeds what is permitted by the internal pointer size. MyISAM permits data and index files to grow up to 256TB by default, but this limit can be changed up to the maximum permissible size of 65,536TB (2567 − 1 bytes).

Is MySQL good for large database?

MySQL is also built to be highly compatible with a wide range of systems, programming languages and database models. This includes alternative DBMS solutions, SQL and NoSQL databases and cloud databases.

Can MySQL handle 100 million records?

Can MySQL handle 100 million records? Yeah, it can handle billions of records. If you properly index tables, they fit in memory and your queries are written properly then it shouldn't be an issue.

You may take a look at long list here: MySQL Gotchas