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

The editor will share with you what the mysql version number has. I hope you will gain a lot after reading this article. Let's discuss it together.

Mysql version numbers are: 3.x to 5.1.X this is the earliest MySQL version, 5.4.X to 5.7.X is now the mainstream version, 6.0.X to 7.1.X is to better promote the MySQL Cluster version and improve the performance of the version

MySQL version number

Example: the 5.5.60 version of MySQL describes each numeric meaning (mysql-5.5.60.tar.gz) of the version number.

First number (5) Major version number: when the file format changes, it will be released as a new version (5.5.60)

Second number (5) release number: if new features or changes are not compatible, the release number needs to be changed (5.5.60)

The third number (60) release serial number: mainly minor changes, such as bug fixes, function additions or changes, configuration parameter changes, etc. (5.5.60).

The MySQL version query method is used for system installation:

Login MySQL method

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

Direct query method without login

$mysql-uroot-p # Connect 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 is divided into MySQL

3.x to 5.1.X

This is the earlier version of MySQL.

The common early versions are: 4.1.7, 5.0.56 and so on.

5.4.X to 5.7.X

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

It is now the mainstream version. Commonly used version: 5.5

6.0.X to 7.1.X

This is to better promote the MySQL Cluster version, as well as to improve MySQL performance and stability as well as new features. Change the basic functionality of MySQL to provide more efficient support for optimization of the Cluster storage engine. Because of the late release time, there are already other means to solve the technical problems of MySQL cluster, so it has not been well promoted and used.

After reading this article, I believe you have a certain understanding of the mysql version number, want to know more related knowledge, 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.