Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For Windows installations, you can speed up MySQL performance by adding the following parameter to the appropriate MySQL.ini file:
 

<pre>
innodb_flush_log_at_trx_commit=0
</pre>
Panel
Html bobswift

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:

html-bobswift
Panel
<pre>
show parameter open_cursors
</pre>

A listing similar to the following will display:

html-bobswift
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:

<pre>
alter system set open_cursors=1000
</pre>
Panel
Html bobswift

To make a permanent change, you must set the open_cursors value in the initialization parameters file.
 

Note
titleNote

If you do not set open_cursors to 1000, you could receive the following error message during large imports:
 

html-bobswift
Panel
<pre>
ORA-01000: maximum open cursors exceeded
</pre>



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.

...