Difference between revisions of "MySQL"
From OpenKM Documentation
(→Change mysql default engine to InnoDB) |
(→Change MySQL default engine to InnoDB) |
||
| Line 29: | Line 29: | ||
<source lang="sql"> | <source lang="sql"> | ||
| − | SHOW TABLE STATUS WHERE name like 'OKM_%' | + | SHOW TABLE STATUS WHERE name like 'OKM_%'; |
</source> | </source> | ||
Revision as of 09:08, 3 April 2013
Download MySQL JDBC driver from MySQL Home Page and move it to $JBOSS_HOME/server/default/lib.
 |
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:
