Mysql/MariaDB禁用InnoDB的方法

InnoDB很强大,不过VPS一般内存不大,用这个比较吃内存。如果你不用InnoDB,可以把它禁用。 方法:新建一个文件:/etc/mysql/conf.d/noinno.cnf,内容为: [mysqld] skip-innodb default-storage-engine=MyISAM default-tmp-storage-engine=MyISAM loose-innodb-trx=0 loose-innodb-locks=0 loose-innodb-lock-waits=0 loose-innodb-cmp=0 loose-innodb-cmp-per-index=0 loose-innodb-cmp-per-index-reset=0 loose-innodb-cmp-reset=0 loose-innodb-cmpmem=0 loose-innodb-cmpmem-reset=0 loose-innodb-buffer-page=0 loose-innodb-buffer-page-lru=0 loose-innodb-buffer-pool-stats=0 loose-innodb-metrics=0 loose-innodb-ft-default-stopword=0 loose-innodb-ft-inserted=0 loose-innodb-ft-deleted=0 loose-innodb-ft-being-deleted=0 loose-innodb-ft-config=0 loose-innodb-ft-index-cache=0…