...
For Windows installations, you can speed up MySQL performance by adding the following parameter to the appropriate MySQL.ini
file:
Panel | |
---|---|
Html bobswift | innodb_flush_log_at_trx_commit=0
</pre> |
For more information about this parameter, see the MySQL documentation:
...
Prior to considering the enabledTLSProtocols connection property , you should verify the database connection using the latest Universal Controller maintenance release, as it may be using a more recent MySQL Connector/J, with functionality changed or added.
https://docsstonebranchdocs.stonebranchatlassian.comnet/confluencewiki/display/SMLRI/Universal+Controller+Maintenance+Lists
https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-usagenotes-known-issues-limitations.html
...
To check the current value for maximum open cursors, issue the following sql*plus utility command:
Panel |
---|
<pre>
show parameter open_cursors
</pre> |
A listing similar to the following will display:
Panel |
---|
<pre>
SQL> show parameter open_cursors;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 1000
</pre> |
Setting a New Value for open_cursors
You can temporarily set the open_cursors
value with the following SQL:
Panel | |
---|---|
Html bobswift | alter system set open_cursors=1000
</pre> |
To make a permanent change, you must set the open_cursors
value in the initialization parameters file.
Note | |||
---|---|---|---|
| |||
If you do not set
|
Character Sets
Universal Controller does not stipulate a requirement for the Oracle database character set; for multilingual support, you can use the default Unicode character set of AL32UTF8.
...