Essential MySQL Features
Completion requirements
Read this article on MySQL features you need to know. Pay attention and list the reasons that explain why MySQL is important. How does MySQL provide high performance and data security?
Data dictionary
The biggest change is behind the scenes with the new data dictionary. If you have ever gone wandering under /var/lib/mysql with a previous version and been confused by the myriad of little files, then you have seen the metadata for your instance. That metadata is now stored in the database itself in the data dictionary. So, besides freeing up inodes, you now can have millions of tables in a schema. The downside is, well, now you can have millions of tables in a schema.