Mysql – Unknown table engine ‘InnoDB’

innodbMySQL

Recently, I have found out that I can maximize mysql performance when if I have good hardware. Since I've been using InnoDB I added additional configuration into my.ini

Here is the newly added configurations:

innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_size = 2G
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 256M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 120

Then I restart all of the services. But when I used my program, an error occurred "Unknown table engine 'InnoDB'".

What I have tried to solve this problem:

  1. I delete the log file the restart the service but I still got the error.

Best Answer

Other solutions did not fix my problem. InnoDB engine was disabled after adjusting config.

Removing borked ib_* log files in mysql data dir fixed my issue, and allowed me to use 2G buffer pool for InnoDB: http://www.turnkeylinux.org/forum/support/20090111/drupal-6-problem-enable-innodb#comment-131

Related Topic