未知的表引擎'InnoDB' [英] Unknown table engine 'InnoDB'

问题描述

最近，我发现，如果我拥有良好的硬件，则可以最大限度地提高mysql性能.由于我一直在使用InnoDB，因此我在my.ini中添加了其他配置

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

这是新添加的配置:

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

然后，我重新启动所有服务.但是，当我使用我的程序时，发生错误未知表引擎'InnoDB'".

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

我试图解决的问题:

1. 我删除了日志文件以重新启动服务，但是仍然出现错误.

推荐答案

其他解决方案无法解决我的问题. 调整配置后，InnoDB引擎被禁用.

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

在mysql数据目录中删除烦人的ib_ *日志文件解决了我的问题，并允许我为InnoDB使用2G缓冲池: http://www.turnkeylinux.org/forum/support/20090111/drupal-6-problem-enable-innodb#comment-131

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

这篇关于未知的表引擎'InnoDB'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！