This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

Disabling storage engines

How I can disable unnecessary storage engines? For my web-site I only need Aria and (probably) InnoDB/XtraDB. From console I can see that most storage engines are enabled by default using query "show plugins;".

From config file I can disable only few engines with next lines:

skip-federated
skip-blackhole
skip-archive
skip-sphinx

But CSV, Memory, MyISAM and Merge engines still enabled and when I try to add skip-memory or another engine server won't start then.

Answer

Do

mysqld --help

For all engines that can be disabled, you will see a corresponding --skip-* command line option. If the --skip-* option does not exist for a certain engine, this engine is mandatory and can not be disabled at all.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.