Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » MobiLink - Server Administration » MobiLink Server Options

-w option Next Page

-wu option


Sets the maximum number of database worker threads that can apply uploads to the consolidated database simultaneously.

Syntax

mlsrv10 -c "connection-string" -wu count ...

Remarks

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 mlsrv10 -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.

Example

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.

See also