← Back to team overview

maria-discuss team mailing list archive

Re: Why MyISAM as default engine for system tables ?


2018-06-06 17:21 GMT+03:00 Roberto Spadim <roberto@xxxxxxxxxxxxx>:
> Last time i had a innodb problem i changed all innodb to one file per table

Unfortunately, there still is the single point of failure for InnoDB:
the system tablespace. It contains the InnoDB data dictionary and the
state of the transaction system. If it becomes corrupted, you can be
really out of luck. You can try to import your .ibd files to an empty
server instance and hope for the best.

I hope that some day we will be able to eliminate it in MariaDB, and
have a transactional, crash-safe data dictionary implemented above the
storage engine layer. At the minimum, create/drop/rename operations of
.frm files would be logged like transactions.

I have written down some plans regarding this:
Marko Mäkelä, Lead Developer InnoDB
MariaDB Corporation