Mysql – InnoDB not enabled

innodbMySQL

I have a mysql database that when I run SHOW ENGINES; innodb does not show up as an engine.

This seems strange as I have an identical server setup where innodb is enabled and in use.

I have checked my.cnf, and there is no skip innodb line as many people have mentioned. I have also deleted my log files as another couple of people have suggested, but neither of these fixes have helped.

Any ideas? Any way I can start troubleshooting?

Results of SHOW ENGINES;

+------------+---------+-----------------------------------------------------------+--------------+------+------------+
| Engine     | Support | Comment                                                   | Transactions | XA   | Savepoints |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                     | NO           | NO   | NO         |
| CSV        | YES     | CSV storage engine                                        | NO           | NO   | NO         |
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance    | NO           | NO   | NO         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables | NO           | NO   | NO         |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
4 rows in set (0.00 sec)

Best Answer

I've seen this issue before in my own set up it has to do mostly with trying to use a memory pool that is larger than your available memory. Check your my.cnf file to ensure your settings conform to your available memory.