# creating innodb engine

**URL:** <https://forums.percona.com/t/creating-innodb-engine/1080>\
**Category:** Other MySQL® Questions\
**Created:** [February 11, 2009, 1:31pm UTC](https://forums.percona.com/t/creating-innodb-engine/1080 "2009-02-11T13:31:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![csanghvi](https://avatars.discourse-cdn.com/v4/letter/c/3bc359/32.png) [@csanghvi](https://forums.percona.com/u/csanghvi)\
**Post date:** [February 11, 2009, 1:31pm UTC](https://forums.percona.com/t/creating-innodb-engine/1080/1 "2009-02-11T13:31:45Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![csanghvi](https://avatars.discourse-cdn.com/v4/letter/c/3bc359/32.png) [@csanghvi](https://forums.percona.com/u/csanghvi)\
**Post date:** [February 11, 2009, 7:39pm UTC](https://forums.percona.com/t/creating-innodb-engine/1080/2 "2009-02-11T19:39:58Z")

</div>

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.