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..
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_%';
To see all the tables included in a database:
SHOW FULL TABLES FROM okmdb;
You can also filter by table name:
SHOW FULL TABLES FROM okmdb LIKE 'OKM_%'
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