HostOnNet Blog

ERROR 1286 (42000): Unknown storage engine ‘InnoDB’

After upgrading MySQL to MariaDB 10.0.23, i got following error

root@server48 [/usr/local]# mysql jscsocce_jsc
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 11515
Server version: 10.0.23-MariaDB MariaDB Server

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [jscsocce_jsc]> select * from school;
ERROR 1286 (42000): Unknown storage engine 'InnoDB'
MariaDB [jscsocce_jsc]> 

This was because InnoDB was not enabled in /etc/my.cnf

To enable InooDB, edit

vi /etc/my.cnf

add

innodb_buffer_pool_size=16M
innodb_additional_mem_pool_size=500K
innodb_log_buffer_size=500K
innodb_thread_concurrency=2
innodb_file_per_table=1

Now restart MariaDB, on CentOS 7 server, run

systemctl stop mariadb
systemctl start mariadb

Posted in MySQL