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

CS-Polaris

已于 2024-07-08 11:09:31 修改

阅读量959

点赞数 13

分类专栏：数据库技术栈文章标签： database 数据库 mysql

于 2024-01-19 11:46:53 首次发布

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

版权

数据库技术栈专栏收录该内容

4 篇文章 0 订阅

订阅专栏

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

数据库技术栈 —— MySQL、MariaDB、InnoDB的基础知识

一、MariaDB是什么？
二、数据库存储引擎：MyISAM vs. InnoDB
三、Mysql的架构
- 3.1 mysql与mysqld的区别

一、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就可以。