creating innodb engine

MySQL & MariaDB Other MySQL® Questions
1

I am trying to create a simple table with Innodb engine.

CREATE TABLE customers (a INT, b CHAR (20), INDEX (a)) ENGINE=InnoDB;

But, when i do
SHOW TABLE STATUS LIKE ‘customers’;

In the Engine type column, it says Myisam. Can some one please help!
Name: customers
Engine: MyISAM
Version: 10
Row_format: Fixed

Thanks.

2

Fixed it.

2 things t o look out for

  1. skip innodb should be commented
  2. Check the error logs. I was trying to allocate a large value for the innodb_buffer_pool_size.