SDB/NotesMySQL
From Jena Wiki
Contents |
National Characters
SDB formats all table columns used for storing text in the MySQL schema to UTF-8. However, this does not cause the data to be transmitted in UTF-8 over the JDBC connection.
The best way is to run the server with a default character set of UTF-8. This is set in the MySQL server configuration file:
[mysql] default-character-set=utf8
A less reliable way is to pass parameters to the JDBC driver in the JDBC URL. The application will need to explicitly set the JDBC URL in the store configuration file.
...?useUnicode=true&characterEncoding=UTF-8
Connection timeouts
If you get the connection timing out after (by default) 8 hours of no activity, try setting autoReconnect=true in the JDBC URL.
Tuning
- For InndoDB, the critical parameter is
innodb_buffer_pool_size. See the MySQL sample configuration files for details. - Using ANALYZE TABLE on the database tables can improve the choices made by the MySQL optimizer.
