数据库（MySql）与引擎（InnoDB）的关系？

There's 10 million articles out there comparing MyISAM to InnoDB (two so-called database engines), which Wikipedia vaguely defines as:

有超过1000万篇文章将MyISAM与InnoDB（两个所谓的数据库引擎）进行比较，*模糊地将其定义为：

"...the underlying software component that a database management system (DBMS) uses to create, read, update and delete (CRUD) data from a database."

“......数据库管理系统（DBMS）用来从数据库创建，读取，更新和删除（CRUD）数据的底层软件组件。”

But what does that really mean? Surprisingly, I couldn't find a single article talking about the relationship of a DB to its engine!

但这究竟意味着什么？令人惊讶的是，我找不到一篇文章谈论数据库与其引擎的关系！

How does an engine manifest itself in the concrete, real world? Is it that a database is really just a binary file, and that its "engine" is the .exe that handles all I/O to and from the file? Does the engine handle EXPLAIN AND QEPs?

引擎如何在具体的现实世界中表现出来？是数据库实际上只是一个二进制文件，它的“引擎”是处理文件所有I / O的.exe吗？引擎是否处理EXPLAIN和QEP？

I guess what I'm asking is: how do you define which responsibilities are MySQL's, and which activities are the responsibility of its underlying engine?

我想我要问的是：你如何定义MySQL的哪些职责，以及哪些活动是其底层引擎的责任？

1 个解决方案