Difference between revisions of "MySQL"

Revision as of 15:54, 14 July 2013

Download MySQL JDBC driver from MySQL Home Page and move it to $TOMCAT_HOME/lib or $JBOSS_HOME/server/default/lib depending on your OpenKM version..

If you get an error like this: Packet for query is too large (1708726 > 1048576). You can change this value on the server by setting the 'max_allowed_packet' variable. You need to modify your MySQL server configuration file and increase the value of the max_allowed_packet property. Don't forget to restart the MySQL after any change in this file. In Debian based distros like Ubuntu, this configuration file is located at /etc/mysql/my.cnf.

• OpenKM 6.0 (also valid for OpenKM 6.1)
• OpenKM 5.0 (also valid for OpenKM 5.1)
• OpenKM 4.1

Change MySQL default engine to InnoDB

Check if your MySQL installation has InnoDB engin enabled:

 $ mysql -h localhost -u root -p
 mysql> show engines;

In order to change the default storage engine edit /etc/mysql/my.cnf and under [mysqld] section in your ini file, and add:

 default-storage-engine = innodb

InnoDB is the preferred engine because it support transactions. MyISAM is more responsive but does not support transactions.

If you want to show which engine is using every table, do:

SHOW TABLE STATUS WHERE name like 'OKM_%';

Database repair

If you have problems with a database and need to be repaired, you can use this command:

 $ mysqlcheck -u root -p --auto-repair --optimize --all-databases

See also:

• Converting Tables from Other Storage Engines to InnoDB
• Convert your MySQL database from MyISAM to InnoDB