MySQL Forums
Forum List  »  InnoDB

Innodb disabled, why?
Posted by: Jason W
Date: July 11, 2013 04:45AM

Hello,

i Have an Ubuntu 12.04 Server running mysql 5.5.31 and for Magento i need Innodb, but i dont get it enabled.

Command "show engines;" gives me this:
Engine: Innodb
Support: no

Command "SHOW VARIABLES LIKE 'have_innodb';" gives me this:
have_innodb | DISABLED

Command "show engine innodb status;" gives me this:
ERROR 1286 (42000): Unknown storage engine 'innodb'

I tried everything, changing the innodb_log_file_size, editing the my.cnf but i dont get innodb running.


My.cnf file:

[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0


[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking

bind-address = 127.0.0.1
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8

myisam-recover = BACKUP

query_cache_limit = 1M
query_cache_size = 16M

log_error = /var/log/mysql/error.log

[root@~]# grep innodb /etc/mysql/my.cnf
innodb_data_home_dir = /var/lib/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql
default-storage-engine=innodb
#default-table-type=innodb
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 40M
innodb_log_file_size = 100M
innodb_log_buffer_size = 4M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_flush_method=O_DIRECT
innodb_fast_shutdown = 0

[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[isamchk]
key_buffer = 16M

!includedir /etc/mysql/conf.d


I really have no more Ideas, i hope you can help me.

Options: ReplyQuote


Subject
Views
Written By
Posted
Innodb disabled, why?
4517
July 11, 2013 04:45AM
1229
July 12, 2013 09:45AM


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.