数据库技术栈 —— MySQL安装与入门基础知识（一）

本文链接：https://blog.csdn.net/weixin_44327736/article/details/135605754

本文深入探讨了MySQL与MariaDB的关系、主要区别以及数据库存储引擎MyISAM与InnoDB之间的对比。分析了MariaDB作为MySQL分支的发展背景，强调其兼容性和独立性。同时，详细介绍了InnoDB作为首选存储引擎的原因，包括稳定性、速度和事务支持等方面的优势。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

前言

如何安装mysql

参考文章或视频资料
[1] 在Windows下安装MySql 服务 - 简书

在这里插入图片描述

一、MariaDB是什么？

Q:MySQL与MariaDB的区别是什么？
MariaDB是MySQL的一个分支，可以认为MariaDB是兼容MySQL的^[1]，为避免被Oracle裹挟和绑定，可以及时跳下Oracle的船，用MariaDB进行替代^[2]，MariaDB在数据文件格式的定义，及client protocols, client APIs, ports, and sockets上都是兼容MySQL的^[3]。

一、参考文章或视频资料
[1] 《mariadb与mysql的区别》- 百度知道
[2] The difference between choice and vendor lock-in
[3] What’s the Difference Between MariaDB and MySQL?

二、数据库存储引擎：MyISAM vs. InnoDB

Q1:MariaDB与InnoDB的区别又是什么？
首先，MariaDB是数据库，而InnoDB只是数据库存储引擎，二者不在一个层面上。
Q2:MyISAM与InnoDB二者的主要区别
Overall, MyISAM is an older and less efficient storage engine than InnoDB. The most commonly noted differences between these two engines are as follows: InnoDB is more stable, faster, and easier to set up; it also supports transactions. It is the default storage engine of choice for a reason, and you can use the features of InnoDB with no need to worry about compatibility issues. If you need to store large amounts of data or ensure that transactions will work correctly, choose InnoDB.
The MyISAM engine is not very good at storing large amounts of data, because it stores everything in a single table. When you need to add data to the database, you have to lock the entire table, which can cause your database to stop working until it is unlocked. In the InnoDB engine, each row is stored separately in a separate table. This means that when you insert data into a MySQL database, you do not need to lock all rows. ^[1]
总之，MyISAM整体上不如InnoDB，以后选MySQL的存储引擎选InnoDB就可以。