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 database worker threads that can simultaneously apply uploads to the consolidated database. When the limit is reached, a database 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 database 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 database worker threads can apply uploads simultaneously. The number of database 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 database 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 database worker threads you find that throughput is less and the CPU utilization for the consolidated database is lower. With more database worker threads, throughput does not increase because the consolidated database is already processing as fast as it can with 10 workers.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|