Sets the maximum number of database worker threads that can apply uploads to the consolidated database simultaneously.
mlsrv11 -c "connection-string" -wu count ...
Use the -wu option to limit the number of worker threads that can simultaneously apply uploads to the consolidated database. When the limit is reached, a worker thread that is ready to apply its upload to the consolidated database must wait until another finishes its upload.
The most common cause of contention in the consolidated database is having too many worker threads applying uploads simultaneously. Downloads cause far less contention, so they are limited only be the mlsrv11 -w option. for this reason, the -w setting must be greater than or equal to the -wu setting.
By default, all worker threads can apply uploads simultaneously. The number of worker threads that are used is set by the -w option. The default is 5.
In a pilot setup using a LAN and remote databases on PCs, you find that the optimum number of worker threads is approximately 10 for both upload-only and download-only synchronizations, and that corresponds to 100% CPU utilization on the consolidated database. With fewer worker threads you find that throughput is less and the CPU utilization for the consolidated database is lower. With more worker threads, throughput does not increase because the consolidated database is already processing as fast as it can with 10 workers.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|