Shulou(Shulou.com)06/02 Report--

This article shows you the outdated expression analysis in MySQL, which is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

As the default storage engine for MySQL, MyISAM provides a good balance between performance and available features

These features include full-text retrieval, compression, and spatial functions. MyISAM does not support transaction and row-level locks.

This is because the MySQL version of the book has not reached 5.1 yet.

Https://dev.mysql.com/doc/refman/5.5/en/innodb-introduction.html

InnoDB is a general-purpose storage engine that balances high reliability and high performance. Starting from MySQL 5.5.5, the default storage engine for new tables is InnoDB rather than MyISAM. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE= clause creates an InnoDB table. Given this change of default behavior, MySQL 5.5 might be a logical point to evaluate whether tables that use MyISAM could benefit from switching to InnoDB.

After 5.5.5, InnoDB has become the default storage engine for MySQL

InnoDB includes all the features that were part of the InnoDB Plugin for MySQL 5.1, plus new features specific to MySQL 5.5 and higher.

The above is the outdated expression analysis in MySQL. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.