Storage engines
As explained in the previous section, storage engines implement data handling at the physical level. They handle the data files, the data, and the index caches if they exist, and whatever is necessary to efficiently manage and read the data.
The .frm files are an exception. For each table, one .frm file exists. These files contain the definition of the table, and are created and used by the server.
Using the SHOW ENGINES statement or querying the information_schema.ENGINES table, it is possible to see the available storage engines. The following output is obtained with a standard MariaDB 10.0.6 installation:
MariaDB [(none)]> SELECT ENGINE, SUPPORT FROM information_schema.ENGINES \G *************************** 1. row *************************** ...
Get Mastering MariaDB now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
