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

The editor will share with you the comparative analysis of various versions of MySQL. I hope you will gain a lot after reading this article. Let's discuss it together.

MySQL is a relational database management system developed by the Swedish company MySQL AB and currently belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is the best RDBMS (relational database management system) application software.

Comparison of different versions of MySQL:

Mysql5.7: released in 2015, mysql5.7 query performance has been greatly improved, doubling that of MySQL 5.6and reducing the time it takes to establish a database connection.

Mysql5.6: released in February 2013, mysql5.6 version in which InnoDB can limit the problem of excessive memory consumption when a large number of tables are opened, InnoDB performance enhancement. InnoDB deadlock information, such as large memory optimization, can be recorded in error logs to facilitate InnoDB analysis to provide full-text indexing capabilities.

Mysql5.5: the default storage engine of the mysql5.5 version released in December 2010 has been changed to InnoDB multiple rollback segments (Multiple Rollback Segments). The previous innodb version can handle up to 1023 concurrent processing operations, and now mysql5.5 can handle concurrent transactions up to 128K to improve metadata locking in transactions. For example, a statement in a thing needs to lock a table, which will be released at the end of the transaction, rather than at the end of the statement as before. The INFORMATION_SCHEMA ["ski:m"] table has been added, and the new table provides specific information about InnoDB compression and transaction locking.

Mysql5.1: the version of MySQL 5.1 released by 20o8 in 2000 is basically a MyISAM with crash recovery function. It uses table-level locks, but does not conflict between reads and writes, that is, read operations can be performed while any type of update operation is performed, but multiple write operations cannot be concurrent.

Mysql-5.0: prior to the mysql-5.0 version, myisam supported a table size of 4G by default. Since mysql-5.0, myisam supports 256T of form data by default. Myisam caches only index data. In 2005, version 5.0 added stored procedures, server-side cursors, triggers, query optimization and distributed transaction functions.

Mysql-4.1: version 4. 0 Beta released in 2002, MySQL has finally transformed into a mature relational database system. The 2002 version of mysql4.1 added support for subqueries, added UTF-8,GROUP BY statements to the character set, and added ROLLUP,MySQL.user tables to adopt a better encryption algorithm. Tables that support each innodb engine are placed in a separate tablespace. Innodb achieves high concurrency by using MVCC (multi-version concurrency control) and implements four isolation levels of the sql standard, while using a strategy called next-key locking to avoid phantom. In addition, the innodb engine also provides high performance technologies such as insert cache (insert buffer), second write (double write), adaptive hash index (adaptive hash index), pre-read (read ahead) and so on.

Specifically, which MySQL version is good needs to be determined according to the actual application. It is recommended that you refer to the following process for selecting the GA version of MySQL database, as follows:

1. Analyze whether the enterprise business needs to use those basic functions and features of MySQL. The key research directions are: MySQL replication, partition table, Plugin-innodb and so on.

2. The first GA version of the MySQL database product line will be launched for at least 10 months before considering using it in the production environment.

3. The latest GA version of the MySQL database product line is generally not the preferred target. Consider the GA version of the database that is 3 or 4 versions later than the latest version.

4. Read the information of the target database GA version carefully. If you modify a large number of BUG on the basis of the previous version, then this GA version is carefully selected.

5. Read carefully the information of the first version after the GA version of the target database. If the modified BUG has a large amount of information, please directly abandon the target version and advance a version number as the target version.

6. Choose according to the method described in steps 4 and 5, until a version after the selected version has a small amount of BUG modification, very few serious BUG, and is not the latest version of GA

7. Read the BUG repair information of 2 or 3 versions of the selected database GA version in detail, mainly related to the target GA version, and find ways to reproduce it, and find ways to avoid it.

8. The GA version selected by the above seven steps, combined with the functions that may be needed by the enterprise business, must be tested for function and performance.

9. The selected GA version of the database, as an internal development and test database environment, usually takes about 3-6 months to run.

10. Enterprise non-core business can consider adopting the new version of GA.

11. After the above 10 processes, if there is no important functional BUG or performance bottleneck, you can start to consider as a back-end database for all business data services.

After reading this article, I believe you have a certain understanding of the comparative analysis of various versions of MySQL, want to know more about it, welcome to follow the industry information channel, thank you for reading!

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.