Home / server / Questions / 245204
In Process
cewebugil
Asked: 2011-03-10 06:59:39 +0800 CST

How to disable all MariaDB storage engine except MyISAM?

  • 772

(in my.cnf) I've tried default-storage-engine = myisam, skip-innodb, and commented out every innodb features, but none of them works

innodb myisam mariadb

3 Answers

  1. Maria can't disable the Aria/Maria storage engine as it's needed. You can disable most of the others via

    skip-innodb skip-pbxt skip-federated

    just type the following to show all storage engines available and it's current status

    mysql> SHOW PLUGINS;
    • 2

  2. add this to your mysql config file

    disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE"

    It's must be usefull for mysql5.7.

    • 0

  3. I think InnoDB cannot be disabled since this is killer feature of MariaDB

    • -2