Cara Mematikan InnoDB di MySQL

Buka berkas /etc/mysql/my.cnf, lalu tambahkan baris dibawah ini

 [mysqld]  
 innodb=OFF  
 default_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   
 loose-innodb-ft-index-table=0   
 loose-innodb-sys-tables=0   
 loose-innodb-sys-tablestats=0   
 loose-innodb-sys-indexes=0   
 loose-innodb-sys-columns=0   
 loose-innodb-sys-fields=0   
 loose-innodb-sys-foreign=0   
 loose-innodb-sys-foreign-cols=0  

Pastikan hasilnya dengan menjalankan perintah di bawah. Baris yang berisi InnoDB akan terlihat seperti hasil di bawah ini:

 mysql -u root -p  
 show engines;  
 +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+  
 | Engine       | Support | Comment                            | Transactions | XA  | Savepoints |  
 +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+  
 | PERFORMANCE_SCHEMA | YES   | Performance Schema                       | NO      | NO  | NO     |  
 | MRG_MYISAM     | YES   | Collection of identical MyISAM tables             | NO      | NO  | NO     |  
 | MEMORY       | YES   | Hash based, stored in memory, useful for temporary tables   | NO      | NO  | NO     |  
 | BLACKHOLE     | YES   | /dev/null storage engine (anything you write to it disappears) | NO      | NO  | NO     |  
 | MyISAM       | DEFAULT | MyISAM storage engine                     | NO      | NO  | NO     |  
 | CSV        | YES   | CSV storage engine                       | NO      | NO  | NO     |  
 | ARCHIVE      | YES   | Archive storage engine                     | NO      | NO  | NO     |  
 | FEDERATED     | NO   | Federated MySQL storage engine                 | NULL     | NULL | NULL    |  
 | InnoDB       | NO   | Supports transactions, row-level locking, and foreign keys   | NULL     | NULL | NULL    |  
 +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+  

Referensi: https://dev.mysql.com/doc/refman/5.6/en/innodb-turning-off.html