17.19. Other Options

lightdb_enable_default_tablespace (integer)

Enables or disables default tablespace lt_users for create database. This is off by default.

lightdb_external_virtual_ip (string)

Configure the external virtual IP. If there is an external virtual IP, before the standby automatically switches to primary, it will determine whether the local machine has this IP address. If there is no IP address, it will not be promoted automatically. see ltcluster

lt_statement_rollback_enable (integer)

Turn statement level rollback on or off in the transaction block. This is off by default. This function takes effect in Oracle or MySQL mode. Statement level rollback is enabled, and the performance loss is about 5%. It is better not to set this switch in the transaction block, which may cause unexpected errors. When using lt_dump, you also need to turn it off.

lightdb_aborted_rollback (boolean)

Lightdb_aborted_rollback is off by default. Enable lightdb_aborted_rollback, report an error and rollback all statements when an error occurs in a transaction. The lt_statement_rollback_enable parameter has been opened, you cannot set Lightdb_aborted_rollback, it will fail to execute. The opposite is the same.

lightdb_sql_mode (String)

lightdb_sql_mode specifies some SQL execution rules, separated by commas. The following rules are supported: no_zero_date.

This setting can be changed within individual sessions.

English|中文