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.

results matching ""

    No results matching ""