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

This article mainly explains "what is the difference between mariadb and mysql". The explanation in this article is simple and clear, easy to learn and understand. Please follow the ideas of Xiaobian to study and learn "what is the difference between mariadb and mysql" together.

The differences between mariadb and mysql are: 1. mysql is a relational database management system, while MariaDB is a branch of MySQL;2. MariaDB is developed by the father of MySQL, and its purpose is to be fully compatible with MySQL;3. XtraDB replaces MySQL's InnoDB.

Operating environment: Windows 7 system, Mysql 5.7.14 version, Dell G3 computer.

What is the difference between Mariadb and MySQL?

Talking about the difference between MySQL and MariaDB (Mariadb and MySQL performance comparison)

mysql profile:

MySQL is a relational database management system, developed by MySQL AB in Sweden, which belongs to Oracle's products. MySQL is one of the most popular relational database management systems, and in terms of WEB applications, MySQL is one of the best RDBMS (Relational Database Management System) applications.

MySQL is a relational database management system that stores data in different tables rather than storing all data in one large repository, which increases speed and flexibility.

MySQL uses SQL, the most commonly standardized language for accessing databases. MySQL software uses a dual licensing policy, divided into community version and commercial version, because of its small size, speed, low total cost of ownership, especially open source this feature, generally small and medium-sized website development choose MySQL as a website database.

MariaDB introduced:

MariaDB database management system is a branch of MySQL, mainly maintained by the open source community, using the GPL license. One of the reasons for this fork was that Oracle acquired MySQL and there was a potential risk of closing MySQL, so the community branched out to avoid that risk.

MariaDB is designed to be fully compatible with MySQL, both API and command line, making it an easy replacement for MySQL.

MariaDB was developed by MySQL founder Michael Videnius, who sold his company MySQL to SUN for $1 billion, and then, with SUN acquired by Oracle, MySQL ownership fell into Oracle's hands.

MariaDB is named after Michael Vidnius 'daughter Maria.

MariaDB followed MySQL versions up to version 5.5. Therefore, people who use MariaDB 5.5 will learn all the features of MariaDB from MySQL 5.5. Starting with version 10.0.0, released on November 12, 2012, MySQL version numbers are no longer followed. Version 10.0.x builds on version 5.5, adding features ported from MySQL version 5.6 and new homegrown features.

On the storage engine side, XtraDB (code-named Aria) was used instead of MySQL's InnoDB starting with version 10.0.9.

MariaDB's API and protocol are MySQL compatible, and features have been added to support native 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, Fedora plans to replace MySQL with MariaDB in Fedora 19 due to concerns that Oracle MySQL is a more closed software project.

MySQL believes that everyone knows what it is.

So what exactly is mariadb?

MariaDB database management system is a branch of MySQL. It was developed by Michael, the father of MySQL. One of the reasons for this fork was that Oracle acquired MySQL and there was a potential risk of closing MySQL, so the community branched out to avoid that risk.

So who's better and who's worse, we're now on the same computer under a simple test.

My laptop environment is

cpu ：I3

Hard disk: ordinary mechanical hard disk (5400 rpm)

Memory: 8G

System: win10 64 bit

MYSQL Version: 5.6

MariaDB Version: 10.3

The following is to insert tens of millions of test data IDs as primary keys in MYSQL and mariaDB respectively. Database engine: MyISAM

Query statements are run under Navicat

1. The 20 data items after the 9 million items are the following statements

select * from usertb limit 9000000,20

MySQL processing time is 3.09 seconds.

MariaDB runs in 1.89 seconds

2. The 20 pieces of data after querying 9 million pieces are the following statement in reverse order according to ID

select * from usertb order by id desc limit 9000000,20

MYSQL time 121.26 seconds

MariaDB takes 75.73 seconds

3. Finally, let's test it with a different SQL statement. Use the following SQL statement (MYSQL's usual pagination optimization statement):

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.