No InnoDB support in Ubuntu server 11.10?
Posted by gvansanden on Sunday, 8 January 2012
I installed an 11.10 server, but it seems to miss InnoDB support:
mysql> SHOW VARIABLES LIKE 'have_innodb'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | have_innodb | NO | +---------------+-------+
Am I missing something?
* EDIT * After removing and reinstalling mysql-server, it magically came back! so weird.
Comments
Anonymous (not verified)
Sun, 2012-01-08 15:54
Permalink
apt-get install postgresql
apt-get install postgresql
Andreas Roth (not verified)
Sun, 2012-01-08 15:57
Permalink
There should be innodb support
i have install mysql-server-5.1 (version 5.1.58-1ubuntu1) and i have innodb support:
root@natty:/ # echo "SHOW VARIABLES LIKE 'have_innodb';" | mysql
Variable_name Value
have_innodb YES
Frederik (not verified)
Sun, 2012-01-08 16:37
Permalink
It's not called xtradb or
It's not called xtradb or something like that? Mariadb and percona use this fork of innodb.
Jacob (not verified)
Sun, 2012-01-08 16:47
Permalink
Shot in the dark, but as of
Shot in the dark, but as of MySQL 5.5, InnoDB is the default storage engine, so maybe that variable isn't present anymore?
...except from looking in the archives, Ubuntu still ships 5.1. Hmm.
robbyt (not verified)
Sun, 2012-01-08 18:06
Permalink
Check your mysql error log.
Check your mysql error log. Innodb is really sensitive to misconfiguration. If something like your transaction log size doesnt match, it just wont load.