The SQL Parser and Storage Engine Tiers
The MySQL server executes SQL statements independent of the storage engines. The server executes each statement using a two-tier model :
The upper tier includes the SQL parser and optimizer. The tier does not interact with the tables directly
The lower tier comprises of a set of storage engines. The engines are used for managging tables of a particular type. The storage engine associated with a table directly accesses it to store or retrieve data.