Turn off InnoDB support in MySQL

Turn off InnoDB support in MySQL

Answer:

If you never use the InnoDB storage engine in MySQL, it is better to disable it.

To disable this feature, edit the MySQL configurations, e.g. /etc/my.cnf

[mysqld]
...
...
skip-innodb

Add the "skip-innodb" will do the tricks for you.

Don't forget to restart MySQL to take effect.

# /sbin/service mysqld restart

Related posts:

1. Disable DNS hostname lookup in MySQL
2. Disable MySQL server from listening for TCP/IP connections
3. Changing the default storage engine in MySQL
4. Set the maximum allowed number of connections in MySQL
5. Enable external locking in MySQL