Difference between revisions of "MySQL"
From OpenKM Documentation
m |
|||
| Line 9: | Line 9: | ||
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''.}} | 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''.}} | ||
| + | |||
| + | {{Advice|[http://en.wikipedia.org/wiki/InnoDB InnoDB] seems to work better than [http://en.wikipedia.org/wiki/MyISAM MyISAM].}} | ||
* [[MySQL-OpenKM 5.0 | OpenKM 5.0]] [[File:Padlock.gif]] (also valid for OpenKM 5.1) | * [[MySQL-OpenKM 5.0 | OpenKM 5.0]] [[File:Padlock.gif]] (also valid for OpenKM 5.1) | ||
Revision as of 10:31, 30 September 2011
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. |
 |
InnoDB seems to work better than MyISAM. |
- OpenKM 5.0
(also valid for OpenKM 5.1) - OpenKM 4.1
