Innodb storage engine not available

Discussion in 'MySQL' started by alexcl, Aug 7, 2011.

  1. #1
    Hi, I installed MariaDB 5.2.7, using the script Centmin v1.2.1-eva2000.03 (http://vbtechsupport.com/920/) and is running fine, but do not have available the Innodb Engine, and I can not convert some tables from myisam to Innodb

    ¿How I can activate the Innodb storage engine in MySQL(MariaDB)?

    
    MariaDB [(none)]> show plugins;
    +--------------------------------+----------+--------------------+---------+---------+
    | Name                           | Status   | Type               | Library | License |
    +--------------------------------+----------+--------------------+---------+---------+
    | binlog                         | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | mysql_native_password          | ACTIVE   | AUTHENTICATION     | NULL    | GPL     |
    | mysql_old_password             | ACTIVE   | AUTHENTICATION     | NULL    | GPL     |
    | MyISAM                         | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | partition                      | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | ARCHIVE                        | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | BLACKHOLE                      | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | CSV                            | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | FEDERATED                      | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | MEMORY                         | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | Maria                          | ACTIVE   | DAEMON             | NULL    | GPL     |
    | Aria                           | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | MRG_MYISAM                     | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | PBXT                           | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
    | PBXT_STATISTICS                | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | InnoDB                         | DISABLED | STORAGE ENGINE     | NULL    | GPL     |
    | INNODB_RSEG                    | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_BUFFER_POOL_PAGES       | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_BUFFER_POOL_PAGES_INDEX | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_BUFFER_POOL_PAGES_BLOB  | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_TRX                     | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_LOCKS                   | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_LOCK_WAITS              | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_CMP                     | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_CMP_RESET               | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_CMPMEM                  | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_CMPMEM_RESET            | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_TABLE_STATS             | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_INDEX_STATS             | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | XTRADB_ADMIN_COMMAND           | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_SYS_TABLES              | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_SYS_INDEXES             | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | INNODB_SYS_STATS               | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    | XTRADB_ENHANCEMENTS            | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
    +--------------------------------+----------+--------------------+---------+---------+
    34 rows in set (0.00 sec)
    Code (markup):

     
    alexcl, Aug 7, 2011 IP
  2. alexcl

    alexcl Active Member

    Messages:
    22
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #2
    Wow, was just setting the following in the my.cnf

    #skip-innodb
     
    alexcl, Aug 7, 2011 IP
  3. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #3
    Good to know that you fixed the problem yourself.
     
    mwasif, Aug 7, 2011 IP
  4. alexcl

    alexcl Active Member

    Messages:
    22
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #4
    Another additional thing I did was change the directory of temporary files of MySQL in the file /etc/my.cnf on the variable tmpdir=

    before:
    tmpdir = /tmp

    Currently:
    tmpdir = /var/lib/mysql/tmp

    MySQL could not write or delete files in /tmp, despite having chmod 1777, also try creating another directory /tmpmysql, assigning permissions chmod 1777, but neither worked. Innodb not to appear on the list for the problem, which could not write to the temporary directory, but the only solution was to leave tmpdir in /var/lib/mysql/tmp
     
    alexcl, Aug 7, 2011 IP
  5. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #5
    You should have change the owner of /tmpmysql to the same under which MySQL is running probably mysql.
     
    mwasif, Aug 7, 2011 IP
  6. alexcl

    alexcl Active Member

    Messages:
    22
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #6
    Also try running the following:

    chown mysql:mysql /tmpmysql

    But neither worked.
     
    alexcl, Aug 7, 2011 IP
  7. p4guru

    p4guru Active Member

    Messages:
    78
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    73
    #7
    what exact error messages you getting that let you believe it's tmpdir issue ? checked mysql error log for clues ?
     
    p4guru, Aug 8, 2011 IP