patternsqlMinor
InnoDB not enabled
Viewed 0 times
innodbnotenabled
Problem
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;
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)Solution
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.
Context
StackExchange Database Administrators Q#12116, answer score: 2
Revisions (0)
No revisions yet.