Skip to content

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

Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay
  1. Disable DNS hostname lookup in MySQL
  2. Set the maximum allowed number of connections in MySQL
  3. Block a client from connecting to MySQL if too many errors
  4. Change the maximum allowed binary log file size in MySQL
  5. Show which storage engines are available in MySQL

Post a Comment

Your email is never published nor shared. Required fields are marked *
*
*