.deb for lucid is missing XtraDB (innodb)

MySQL & MariaDB Other MySQL® Questions
1

mysql> SELECT @@version, @@version_comment; SHOW ENGINES;±-------------------±-------------------------------------------+| @@version | @@version_comment |±-------------------±-------------------------------------------+| 5.1.47-rel11.2-log | (Percona Server (GPL), 11.2 , Revision 53) |±-------------------±-------------------------------------------+1 row in set (0.00 sec)±-----------±--------±---------------------------------------------------------------±-------------±-----±-----------+| 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 |±-----------±--------±---------------------------------------------------------------±-------------±-----±-----------+

Donloaded the server from here: http://www.percona.com/downloads/Percona-Server-5.1/Percona- Server-5.1.47-11.2/deb/lucid/i686/

2

Hi there,

have you configured innodb properly?

You got all the files it should?

Thanks,
Istvan

3

This looks like a bug in the build. If InnoDB is configured wrong, it would show as DISABLED, but it would still be in the list.

4

Actually I figured it out. Hosting provider installed 32 bit system instead of 64 and I’ve got InnoDb configured with 3GB buffer pool. InnoDB just died and MySQL itself was working. Had to go through the logs quite thorolly.