Shulou(Shulou.com)05/31 Report--

This article mainly introduces the branch version of MySQL, which has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

1.MarriDB

MariaDB is a version of the Monty branch that is one of the founders of MySQL. After MySQL database was acquired by Oracle, Monty worried about the future of MySQL database development, so it spent one version. This version is very different from other branches.

It uses the new Maria storage engine by default, which is an upgraded version of the original MyISAM storage engine. In addition, it adds support for Hash Join and optimizes Semi Join, making MariaDB perform better than the original version of MySQL in complex analytical SQL statements

It's improved a lot. In addition, it not only includes some original storage engines, such as InnoDB and Memory, but also integrates PBXT and FederatedX storage engines.

2.Percona Server

Percona Server is a MySQL database version of a branch of Percona. This version optimizes the InnoDB storage engine under high load, and provides some very useful performance diagnosis tools for DBA.

There are also more parameters and commands that can be used to control server behavior. Percona's biggest contribution is the release of a free and open source XtraBackup tool that enables online hot backup of InnoDB storage engine tables.

3.InnoSQL

InnoSQL is a MySQL version of the author's branch that aims to provide better database performance and to apply some creative ideas to the database's production environment. InnoSQL is fully compatible with the Oracle MySQL version

All added patches, plug-ins, and storage engines are dynamic. If these functions are not enabled, then it is exactly the same as the original version. At present, its unique functions are:

InnoDB Flash Cache

InnoDB Share Memory

IO Statistics

Thank you for reading this article carefully. I hope the article "what are the branch versions of MySQL" shared by the editor will be helpful to you. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.