<docbook><section><title>ChangeVirtuosoSDefaultTransactionIsolationLevel</title><title> Changing the Default Transaction Isolation Level for a Virtuoso Server Instance </title> Changing the Default Transaction Isolation Level for a Virtuoso Server Instance 
<para>Note that changing this default may have significant impact on performance.
 For most mixed-use deployments, the unset default of <computeroutput>READ COMMITTED</computeroutput> should be left unchanged.</para><para>Transaction isolation may always be changed for individual <ulink url="http://docs.openlinksw.com/virtuoso/isolation/">SQL sessions</ulink>.</para><para>SPARQL does not support transaction isolation adjustments at the session level, so users focused on RDF interaction may need to adjust this to, for instance, <computeroutput>REPEATABLE READ</computeroutput> or other setting in the table below.</para><orderedlist spacing="compact"><listitem> Log in to the machine that hosts your Virtuoso Universal Server.
</listitem>
<listitem> Open the relevant <computeroutput>virtuoso.ini</computeroutput> file in a text editor.
</listitem>
<listitem> Locate the <computeroutput>[Parameters]</computeroutput> section of the file.
 For example: <programlisting>[Parameters]
ServerPort               = 1111
DisableUnixSocket        = 1
;SSLServerPort           = 2111
...
DefaultIsolation         = 4
...
</programlisting></listitem>
<listitem> Locate the <computeroutput>DefaultIsolation</computeroutput> parameter.
</listitem>
<listitem> Pass the numeric value for the desired isolation level 
<table><title /><tgroup><thead /><tbody>
<row />
<row><entry>  <emphasis>unset</emphasis> </entry><entry>  as if set to 2, READ COMMITTED  </entry></row>
<row><entry>  1  </entry><entry>  READ UNCOMMITTED  </entry></row>
<row><entry>  2  </entry><entry>  READ COMMITTED  </entry></row>
<row><entry>  4  </entry><entry>  REPEATABLE READ  </entry></row>
<row><entry>  8  </entry><entry>  SERIALIZABLE  </entry></row>
</tbody></tgroup></table>
 For example: <programlisting>DefaultIsolation = 1   ; READ UNCOMMITTED
</programlisting></listitem>
<listitem> Save your changes and exit the file.
</listitem>
<listitem> Restart your Virtuoso server.</listitem>
</orderedlist><bridgehead class="http://www.w3.org/1999/xhtml:h2"> Related </bridgehead>
<itemizedlist mark="bullet" spacing="compact"><listitem> <ulink url="http://docs.openlinksw.com/virtuoso/isolation/">Virtuso SQL Transaction Isolation</ulink> </listitem>
<listitem> <ulink url="http://docs.openlinksw.com/virtuoso/lockescalation/">Virtuoso Lock Escalation</ulink> </listitem>
<listitem> <ulink url="http://docs.openlinksw.com/virtuoso/lockescalation/">Virtuoso Locking</ulink> </listitem>
<listitem> <ulink url="https://docs.microsoft.com/en-us/sql/odbc/reference/develop-app/transaction-isolation-levels?view=sql-server-ver15">ODBC Transaction Isolation Levels</ulink> </listitem>
</itemizedlist></section></docbook>