There, 10 million articles compare MyISAM with InnoDB (two so-called database engines), which Wikipedia vaguely defines as:
"... the basic software component used by the database management system (DBMS) to create, read, update and delete (CRUD) data from the database.
But what does it mean? Surprisingly, I could not find a single article about the connection of the database with its engine!
How does an engine manifest itself in a concrete, real world? Is it that the database is just a binary file, and its "engine" is an .exe that handles all the I / O to and from the file? Does the engine support EXPLAIN AND QEP?
I suppose I ask: how do you determine what responsibilities MySQL is and what actions are responsible for its underlying engine?
source share