mysql disable MyISAM


//=== http://stackoverflow.com/questions/19637477/how-to-disable-creation-of-myisam-table-in-mysql

* MyISAM engine is used by mysql system tables

* disable MyISAM storage engine is imposible
--> disable CREATE NEW MyISAM tables.

* set the default_storage_engine server variable to innodb



//=== https://mariadb.com/kb/en/mariadb/disabling-storage-engines/
"""...
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.

..."""

-->
$ mysqld --verbose --help
...
2015-05-06 11:42:25 1989 [Note] Binlog end
2015-05-06 11:42:25 1989 [Note] Shutting down plugin 'MyISAM'
2015-05-06 11:42:25 1989 [Note] Shutting down plugin 'CSV'




* check information_schema.tables for engines

mysql> SELECT engine,GROUP_CONCAT(DISTINCT TABLE_SCHEMA) Table_Schema_List,COUNT(*) FROM information_schema.tables GROUP BY engine;

+--------------------+--------------------------+----------+
| engine | Table_Schema_List | COUNT(*) |
+--------------------+--------------------------+----------+
| CSV | mysql | 2 |
| InnoDB | employees,fex | 7 |
| MEMORY | information_schema | 49 |
| MyISAM | mysql,information_schema | 32 |
| PERFORMANCE_SCHEMA | performance_schema | 17 |
+--------------------+--------------------------+----------+
5 rows in set (0.17 sec)