Announcement

Announcement Module
Collapse
No announcement yet.

creating innodb engine

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • creating innodb engine

    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.

    Comment

    Working...
    X