SEC_APPLY_POLLTIME configuration parameter

Use the SEC_APPLY_POLLTIME configuration parameter to control how long log replay thread should poll for new work before yielding.

onconfig.std value

SEC_APPLY_POLLTIME 0

values
  • Minimum value: (Default) 0
  • Recommended value for smaller systems (between 1 to 8 CPUVPs): 0
  • Recommended value for medium systems (between 8 and 16 CPUVPS): 10
  • Recommended value for larger systems (> 16 CPUVPS): 1000
  • Maximum value: 5000
units

micro seconds.

takes effect

After you edit your onconfig file and restart the database server.

When you reset the value dynamically in your onconfig file by running the onmode -wf command.

When you reset the value in memory by running the onmode -wm command.

Usage

In micro seconds, controls how long log replay thread should poll for new work before yielding. Use this parameter to reduce thread context switch overhead while replaying log records. It is recommended to configure poll threads to run on NET VP if SEC_APPLY_POLLTIME value > 0. For more information see, NETTYPE configuration parameter.

Note: SEC_APPLY_POLLTIME plays a significant role on large and very busy clusters, with high volumes of logical log throughput having to be recovered on secondary servers. To set a non zero value for SEC_APPLY_POLLTIME, OFF_RECVRY_THREADS configuration value must be less than CPU VPs configured for the database server.