MySQL Forums
Forum List  »  InnoDB

InnoDB is missing
Posted by: Dimitri Fontaine
Date: January 12, 2011 02:34AM

Hi,

I'm using the mysql version
mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1
on CentOS Linux 5.5.

When I try to use innoDB, I get the following message
Your MySQL server does not support InnoDB tables or InnoDB support is disabled.

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

The engine InnoDB is not available.

When I try to activate it in my.cnf I get the following error message:
110112 02:25:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
110112 2:25:01 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
110112 2:25:01 [ERROR] /usr/local/mysql/libexec/mysqld: unknown variable 'innodb_data_home_dir=/var/lib/mysql/'
110112 2:25:01 [ERROR] Aborting

110112 2:25:01 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

My my.cnf innoDB config is

# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

There is no skip-innodb parameters in the config file.

Any Idea?
Thanks for your help.

Regards
Dimitri

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB is missing
6997
January 12, 2011 02:34AM
1943
January 13, 2011 10:09PM
2068
January 13, 2011 11:32PM
2138
January 14, 2011 09:49AM
2103
January 14, 2011 02:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.