Difference between revisions of "MySQL"
From OpenKM Documentation
(→Change mysql default engine to InnoDB) |
|||
| 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''.}} | ||
| + | |||
| + | * [[MySQL-OpenKM 5.0 | OpenKM 5.0]] [[File:Padlock.gif]] (also valid for OpenKM 5.1) | ||
| + | * [[MySQL-OpenKM 4.1 | OpenKM 4.1]] [[File:Padlock.gif]] | ||
== Change mysql default engine to InnoDB == | == Change mysql default engine to InnoDB == | ||
| Line 25: | Line 28: | ||
* [http://dev.mysql.com/doc/refman/5.0/en/converting-tables-to-innodb.html Converting Tables from Other Storage Engines to InnoDB] | * [http://dev.mysql.com/doc/refman/5.0/en/converting-tables-to-innodb.html Converting Tables from Other Storage Engines to InnoDB] | ||
* [http://highervisibilitywebsites.com/convert-your-mysql-database-myisam-innodb-and-get-ready-drupal-7-same-time Convert your MySQL database from MyISAM to InnoDB] | * [http://highervisibilitywebsites.com/convert-your-mysql-database-myisam-innodb-and-get-ready-drupal-7-same-time Convert your MySQL database from MyISAM to InnoDB] | ||
| − | |||
| − | |||
| − | |||
| − | |||
[[Category: Installation Guide]] | [[Category: Installation Guide]] | ||
[[Category: OKM Network]] | [[Category: OKM Network]] | ||
Revision as of 18:12, 14 February 2012
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 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. |
See also:
