Changes to Parameter Default Values

Except for memory_limit and smp_enable, if you upgrade to Replication Server 15.5, the only values that are set to the new defaults are those that used the defaults in the earlier version.

Changes to Parameter Default Values

Parameter

Old Value

New Value

Downgrading from Version 15.5

exec_cmds_per_timeslice

5

2,147,483,647

Downgrading does not change the value you have set.

init_sqm_write_delay

1000 milliseconds

100 milliseconds for all platforms

Downgrading does not change the value you have set.

init_sqm_write_max_delay

10,000 milliseconds

1000 milliseconds for all platforms

Downgrading does not change the value you have set.

memory_limit

80MB

2,047MB

Upgrading increases the value to the new default if the earlier value was less than 2,047MB.

If the value you set is larger than 2,047MB, downgrading resets the value to 2,047MB to protect against overflow.

smp_enable

off

on

Upgrading does not change the setting to on if your original setting was off.

Downgrading does not change the value you have set.

sqt_max_cache_size

1,048,576 bytes (1MB)

  • 32-bit platforms:

    1,048,576 bytes (1MB)

  • 64-bit platforms:

    20,971,520 bytes (20MB)

If the value set is larger than 2,147,483,647 bytes, downgrading resets the value to 2,147,483,647 bytes to protect against overflow.

sts_full_cache_system_table_name for these system tables:

rs_columns, rs_functions, rs_objects

off – not fully cached

on – fully cached

Downgrading does not change your settings.

See Chapter 3, “Replication Server Commands” in the Replication Server Reference Manual for descriptions of the parameters, examples and usage information.