The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

did not see innodb

Discussion in 'Database Discussions' started by steven_elvisda, Nov 23, 2012.

  1. steven_elvisda

    Joined:
    Nov 15, 2010
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    Dear All,

    I would like to as you that. my vps is not work with innodb.

    after I use command
    mysql> show engines;
    +------------+---------+----------------------------------------------------------------+--------------+------+------------+
    | Engine | Support | Comment | Transactions | XA | Savepoints |
    +------------+---------+----------------------------------------------------------------+--------------+------+------------+
    | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
    | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
    | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
    | CSV | YES | CSV storage engine | NO | NO | NO |
    | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
    | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
    | ARCHIVE | YES | Archive storage engine | NO | NO | NO |
    +------------+---------+----------------------------------------------------------------+--------------+------+------------+
    7 rows in set (0.00 sec)

    there is no innodb

    any idea?

    your idea are very important to me.

    Best Regards,
     
  2. steven_elvisda

    Joined:
    Nov 15, 2010
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    after I use option skip-innodb in my.cnf I saw as below.
    mysql> show engines;
    +------------+---------+----------------------------------------------------------------+--------------+------+------------+
    | Engine | Support | Comment | Transactions | XA | Savepoints |
    +------------+---------+----------------------------------------------------------------+--------------+------+------------+
    | InnoDB | NO | Supports transactions, row-level locking, and foreign keys | NULL | NULL | NULL |
    | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
    | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
    | CSV | YES | CSV storage engine | NO | NO | NO |
    | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
    | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
    | ARCHIVE | YES | Archive storage engine | NO | NO | NO |
    | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
    +------------+---------+----------------------------------------------------------------+--------------+------+------------+
    8 rows in set (0.00 sec)

    mysql>
     
  3. steven_elvisda

    Joined:
    Nov 15, 2010
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    if I use command mysql> SHOW VARIABLES LIKE 'have_innodb';

    I saw as below:

    +---------------+-------+
    | Variable_name | Value |
    +---------------+-------+
    | have_innodb | NO |
    +---------------+-------+
    1 row in set (0.00 sec)
     
Loading...

Share This Page