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

In this issue, the editor will bring you about the difference between MySQL and MariaDB. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

MariaDB database management system is a branch of MySQL, which is mainly maintained by the open source community and licensed by GPL. One of the reasons for developing this branch is that after Oracle acquired MySQL, there is a potential risk of shutting down MySQL, so the community uses a branching approach to avoid this risk.

The goal of MariaDB is to be fully compatible with MySQL, including API and the command line, making it an easy replacement for MySQL.

MariaDB was developed by Michael Vidnius, the founder of MySQL, who had earlier sold his company, MySQL, to SUN for $1 billion, and then MySQL was owned by Oracle as SUN was acquired by Oracle.

The name MariaDB comes from the name of Maria (English: Maria), daughter of Michael Vidnius.

MariaDB follows the MySQL version until version 5. 5. Therefore, people who use MariaDB5.5 will learn all the functions of MariaDB from MySQL5.5. Version 10.0.0, which was released on November 12, 2012, will no longer follow the version number of MySQL. Version 10.0.x is based on version 5.5, plus features migrated from MySQL version 5.6 and new features developed by ourselves.

In terms of the storage engine, version 10.0.9 has used XtraDB (code name Aria) instead of MySQL's InnoDB.

MariaDB's API and protocol are compatible with MySQL, and additional features have been added to support local non-blocking operations and progress reporting.

This means that all connectors, libraries, and applications that use MySQL will also work under MariaDB.

On this basis, because of concerns about a more closed software project of Oracle MySQL, Fedora plans to replace MySQL with MariaDB in Fedora 19.

MYSQL believes that everyone knows exactly what it is. So what is mariadb?

MariaDB database management system is a branch of MySQL. Was developed by Michael, the father of MySQL. One of the reasons for developing this branch is that after Oracle acquired MySQL, there is a potential risk of shutting down MySQL, so the community uses a branching approach to avoid this risk.

So who is good or bad in performance between the two? we are now simply testing it on the same computer.

My notebook environment is

Cpu: I3

Hard disk: ordinary mechanical hard disk (5400 rpm)

Memory: 8GB

System: win10 64 bit

MYSQL version: 5.6

MariaDB version: 10.3

The following is to build a database in MYSQL and mariaDB to insert tens of millions of test data ID as the primary key, database engine: MyISAM

Query statements are all run under Navicat

1. The 20 pieces of data that are queried after 9 million items are the following statement

Select * from usertb limit 90000000.20

The processing time of mysql is 3.09 seconds.

The running time of mariaDB is 1.89 seconds.

two。 The 20 pieces of data after 9 million items are queried in reverse order according to ID is the following statement

Select * from usertb order by id desc limit 90000000.20

MYSQL takes 121.26 seconds

MariaDB takes 75.73 seconds.

3. Finally, let's change the SQL statement to test. Use the following SQL statement (the commonly used MYSQL statement for optimizing paging):

Select * from usertb where id

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.