-
Suggestion
-
Resolution: Low Engagement
-
None
-
1
-
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:
- After configuring Crowd (version 3.2 onwards) with MySQL, edit file crowd.cfg.xml
- Go to property <property name="hibernate.connection.url">jdbc:mysql:example_database?rewriteBatchedStatements=true</property>
- 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.
[CWD-5497] Crowd - Documentation for rewriteBatchedStatements parameter
| Resolution | New: Low Engagement [ 10300 ] | |
| Status | Original: Gathering Interest [ 11772 ] | New: Closed [ 6 ] |
| Labels | New: cleanup-seos-fy25 |
| Remote Link | New: This issue links to "Page (Confluence)" [ 1011946 ] |
| Support reference count | New: 1 |
| Remote Link | New: This issue links to "Page (Confluence)" [ 991660 ] |
| Summary | Original: Crowd 3.7.0 - Documentation for rewriteBatchedStatements parameter | New: Crowd - Documentation for rewriteBatchedStatements parameter |
| Description |
Original:
h3. Suggestion Summary
Create documentation or add information to [Crowd with MySQL page|https://confluence.atlassian.com/crowd/mysql-4030924.html] that clarifies the usage of parameter *rewriteBatchedStatements* found in Crowd JDBC string after configuration with MySQL database. h3. Environment * Crowd 3.2 onwards * [Supported version of MySQL DB|https://confluence.atlassian.com/crowd/supported-platforms-191851.html] h3. Steps to Reproduce: # After configuring Crowd (version 3.2 onwards) with MySQL, edit file crowd.cfg.xml # Go to property <property name="hibernate.connection.url">jdbc:mysql:example_database?rewriteBatchedStatements=true</property> # *rewriteBatchedStatements=true* will be set h3. Expected Results We should have a documentation that allows us to explain customers about parameters from the application. h3. Actual Results We can't find Atlassian documentation that explains parameter *rewriteBatchedStatements*. Hi [~jbondan@atlassian.com], This is Crowd DoS. I just looked at the conversation on the ticket, and I am pleased to see that the customer was able to resolve the performance issue with the help of that index, which makes sense for them because they have extraordinary number of rows in cwd_membership, amounting to more than 3.5 million. Also, one important point to note that since Crowd 3.2 we did some performance improvement with regard to Crowd database connectivity, and {code:java} rewriteBatchedStatements=true {code} is one of them, Crowd automatically adds this parameter if it detects MySQL db, 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. Gaurav Agarwal |
New:
h3. Suggestion Summary
Create documentation or add information to [Crowd with MySQL page|https://confluence.atlassian.com/crowd/mysql-4030924.html] that clarifies the usage of parameter *rewriteBatchedStatements* found in Crowd JDBC string after configuration with MySQL database. h3. Environment * Crowd 3.2 onwards * [Supported version of MySQL DB|https://confluence.atlassian.com/crowd/supported-platforms-191851.html] h3. Steps to Reproduce: # After configuring Crowd (version 3.2 onwards) with MySQL, edit file crowd.cfg.xml # Go to property <property name="hibernate.connection.url">jdbc:mysql:example_database?rewriteBatchedStatements=true</property> # *rewriteBatchedStatements=true* will be set h3. Expected Results We should have a documentation that allows us to explain customers about parameters from the application. h3. Actual Results We can't find Atlassian documentation that explains parameter *rewriteBatchedStatements*. h3. 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. |