InnoDB Not Enabled

Installing, Configuring, Troubleshooting server daemons such as Web and Mail
Post Reply
cdillardhsp
Posts: 4
Joined: 2007/06/04 13:49:35
Contact:

InnoDB Not Enabled

Post by cdillardhsp » 2008/03/07 13:55:27

We have CentOS 5.1 installed with MySQL 5 from the YUM repos. From the mysql> prompt, SHOW ENGINES; shows that INNODB is not enabled. In the my.cnf file --skip-innodb is commented out. Does the version of MySQL that comes from the CentOS repos have InnoDB support or will we need to remove this and install from source?

The mysql log shows this when trying to startup as INNODB:
080307 1:01:53 [ERROR] Default storage engine (InnoDB) is not available
080307 1:01:53 [ERROR] Aborting

SHOW ENGINES reports:

mysql> show engines;
+------------+----------+----------------------------------------------------------------+
| Engine | Support | Comment |
+------------+----------+----------------------------------------------------------------+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables |
| InnoDB | DISABLED | Supports transactions, row-level locking, and foreign keys |
| BerkeleyDB | DISABLED | Supports transactions and page-level locking |
| BLACKHOLE | NO | /dev/null storage engine (anything you write to it disappears) |
| EXAMPLE | NO | Example storage engine |
| ARCHIVE | NO | Archive storage engine |
| CSV | NO | CSV storage engine |
| ndbcluster | NO | Clustered, fault-tolerant, memory-based tables |
| FEDERATED | NO | Federated MySQL storage engine |
| MRG_MYISAM | YES | Collection of identical MyISAM tables |
| ISAM | NO | Obsolete storage engine |
+------------+----------+----------------------------------------------------------------+
12 rows in set (0.00 sec)




Thank you,
Clay

michaelnel
Posts: 1478
Joined: 2006/05/29 16:50:11
Location: San Francisco, CA

InnoDB Not Enabled

Post by michaelnel » 2008/03/07 18:38:12

Yes, this is from a CentOS 5.1 box:

[code]
mysql> show engines;
+------------+---------+----------------------------------------------------------------+
| Engine | Support | Comment |
+------------+---------+----------------------------------------------------------------+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables |
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys |
| BerkeleyDB | YES | Supports transactions and page-level locking |
| BLACKHOLE | NO | /dev/null storage engine (anything you write to it disappears) |
| EXAMPLE | NO | Example storage engine |
| ARCHIVE | NO | Archive storage engine |
| CSV | NO | CSV storage engine |
| ndbcluster | NO | Clustered, fault-tolerant, memory-based tables |
| FEDERATED | NO | Federated MySQL storage engine |
| MRG_MYISAM | YES | Collection of identical MyISAM tables |
| ISAM | NO | Obsolete storage engine |
+------------+---------+----------------------------------------------------------------+
12 rows in set (0.00 sec)

[/code]

Innodb is enabled by default. My /etc/my.cnf doesn't mention innodb at all, so if yours is disabled you must be disabling it somehow, either in my.cnf or perhaps passing a switch in the startup script.

Post Reply

Return to “CentOS 5 - Server Support”