MyISAM/InnoDB switch

1 Requirements

Using the InnoDB instead of the MyISAM engine can improve performance significally for MySQL users. We should support the migration from MyISAM to InnoDB in a way.

E.g.: The setup gets a new tab for the database that lists all tables that can be safely migrated from MyISAM to InnoDB. If the client is deactivated a set of tables can be selected and migrated from one engine to the other.

2 Status

3 Additional Information

4 Discussion

JF 16 Nov 2009: We highly appreciate this idea.

Alex 20 Mar 2012: I suggest to add InnoDB as an additional Database (Engine) switch in the setup (like Postgres and Oracle now).

JF 2 May 2012: We would like to add the setup switch - if possible for 4.3.

FH Aachen (Jochen) 1 June 2012: We are happy to fund this for 4.3

5 Implementation

ILIAS 4.3 implements InnoDB completely as a separate DB type that can be selected during setup.
 
There is currently no "switch" within the setup itself. You can migrate an existing database to InnoDB by altering the DB type of each table "ALTER TABLE [tablename] ENGINE = INNODB;" and set in your client.ini.php:
 
[db]
type = "innodb"
 
instead of the MySQL/MyISAM version:
 
[db]
type = "mysql"
 
See also the MySQL info page on migrating to InnoDB.