Suggestion Summary

Create documentation or add information to Crowd with MySQL page that clarifies the usage of parameter rewriteBatchedStatements found in Crowd JDBC string after configuration with MySQL database.

Environment

• Crowd 3.2 onwards
• Supported version of MySQL DB

Steps to Reproduce:

1. After configuring Crowd (version 3.2 onwards) with MySQL, edit file crowd.cfg.xml
2. Go to property <property name="hibernate.connection.url">jdbc:mysql:example_database?rewriteBatchedStatements=true</property>
3. rewriteBatchedStatements=true will be set

Expected Results

We should have a documentation that allows us to explain customers about parameters from the application.

Actual Results

We can't find Atlassian documentation that explains parameter rewriteBatchedStatements.

Notes from Crowd DoS

rewriteBatchedStatements=true is available since Crowd 3.2 when development did some performance improvements with regard to Crowd database connectivity, and added this parameter as part of the improvements. Crowd will automatically add this parameter if it detects MySQL Database, and similar parameters are in place for other database engines as well.

This is purely meant to improve the performance of Crowd's syncs.

If you would like Crowd to not add this parameter by default then, you should supply the parameter by yourself with false value in the DB connection URL.