MySQL notes[]

The MySQL database is the database back end for most dynamic components of the FACETS website. It usually runs very stable and fast. For most tables we are using the InnoDB storage engine.

On this page I share a few running-Mysql-related notes:

Installation notes[]

aptitude install g++
aptitude install ncurses-dev

December 2008: Upgrading to MySQL 5.1.30[]

I am using a compiled-from-source version of the MySQL database. After switching from Mysql 5.0.x to 5.1.30 the InnoDB tables were not recognized any longer ("missing storage engine").

Reason/fix: the InnoDB storage engine needs to be loaded once as a plugin (http://forums.mysql.com/read.php?11,236861,238281) with the command install plugin InnoDB soname 'ha_innodb.so'; (to issue the command connect to the mysql database e.g. with the mysql client application). This command fails if it is issued on a not-yet-upgraded table set just after the database engine has been upgraded, as the new plugin table does not exist in the old tables. Therefore:

1. run the mysql_upgrade command to create (among other things) the missing table
2. execute install plugin InnoDB soname 'ha_innodb.so'; in the mysql client
3. (if necessary:) run the mysql_upgrade command again (with the --force option) to work also on InnoDb tables (which are now recognized by the database)

The loaded plugins can be shown in the mysql client with the show plugins command

mysql> show plugins;

2014/08/13 new MySQL version installed on Flagship - in a hurry as the old MySql was broken[]

See FlagshipServer