What are the mysql version numbers?

mysql version numbers are: 1. [3.X-5.1.X] This is the earliest MySQL version; 2. [5.4.X-5.7.X] is the current mainstream version; 3. [ 6.0.X-7.1.X [is a version to better promote the MySQL Cluster version and improve performance.

MySQL version number

Example: This version of MySQL 5.5.60 explains the meaning of each number in the version number (mysql-5.5.60.tar.gz).

The first number (5) major version number: when the file format is changed, it will be released as a new version (5.5.60);

The second number (5) release version number : When new features or changes are incompatible, the release version number needs to be changed (5.5.60);

The third number (60) release serial number: mainly small changes, such as bug fixes, functions Additions or changes, changes in configuration parameters, etc. (5.5.60).

System installation uses MySQL version query method:

Login MySQL method

mysql> status;
mysql> select version();
mysql> select @@version;
mysql> show variables like "%version%";

Direct query method without logging in

$ mysql -u root -p             
#连接mysql
$ mysqladmin -uroot -p version;
$ mysql -V
$ mysql --version
$ mysql --help | grep Distrib
$ mysql -? | grep Distrib
$ mysql -I | grep Distrib
$ rpm -qa|grep mysql

Version number divisionMySQL

3.X to 5.1.X

This is an early version of MySQL.

Common early versions include: 4.1.7, 5.0.56, etc.

5.4.X to 5.7.X

This is to integrate the new storage engine developed by the MySQL AB company community and third-party companies. Absorb new implementation algorithms and better support SMP architecture. A lot of code refactoring was done to improve performance.

is now the mainstream version. Commonly used versions: 5.5

6.0.X to 7.1.X

This is to better promote the MySQL Cluster version, as well as improve MySQL performance and stability as well as new features. Change the basic functions of MySQL to provide more effective support and optimization for the Cluster storage engine. Because it was released late, there were already other means to solve MySQL cluster technical problems when it was released, so it was not well promoted and used.

The above is the detailed content of What are the mysql version numbers?. For more information, please follow other related articles on the PHP Chinese website!