SQM Command Cache Memory Configuration

When setting the SQM command cache memory configuration:

• Increase sqm_cmd_cache_size if the Replication Server has a large total SQM cache. Total SQM cache = sqm_cache_size (in pages) * sqm_page_size (in blocks) * block_size (in kilobytes)
• Decrease sqm_max_cmd_in_block if command size or table row size is large.
• Increase sqm_max_cmd_in_block if block_size is large.

After you have set the initial values, tune the values based on replication performance and data from monitoring counters:

• Increase sqm_cmd_cache_size if SQMNoDirectReplicateInCache shows a large value.
• Increase sqm_max_cmd_in_block if SQMNoDirectReplicateInBlock shows a large value.

Use configure replication server to change the sqm_cache_size, sqm_page_size, and block_size for all database connections to Replication Server. Otherwise, use alter queue to set the configuration for a specific database connection.