The Ultimate Guide to High Availability with MariaDB

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.

Comments

Comments loading...
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.