-ppv option

Causes MobiLink to print new periodic monitoring values according to the period specified. Periods are in seconds.

Syntax 
mlsrv11 -c "connection-string" -ppv period ...
Remarks

These values can provide insight into the state of the server, and are useful for determining the health and performance of the MobiLink server. For example, one could look at the DB_CONNECTIONS and LONGEST_DB_WAIT values to look for potential problems with the -w option or in the synchronization scripts. The values also provide an easy way to track system wide throughput measures, such as the number of rows uploaded or downloaded per second and the number of successful synchronizations per second.

The suggested period is 60s.

If the period is set too small, the log will grow very quickly.

Each row of output is prefixed with PERIODIC: to aid in searching for and filtering out the values.

The printed values can include the following information:

  • CMD_PROCESSOR_STAGE_LEN   The length of the queue for synchronization work.

  • CPU_USAGE   The amount of CPU time used by the MobiLink server in microseconds.

  • DB_CONNECTIONS   The number of database connections in use.

  • FREE_DISK_SPACE   The disk space available on the temp disk in bytes.

  • HEARTBEAT_STAGE_LEN   The length of the queue for periodic, non-sync work.

  • LONGEST_DB_WAIT   The longest length of time an active synchronization has been waiting for the database.

  • LONGEST_SYNC   The age of the oldest synchronization in microseconds.

  • MEMORY_USED   The bytes of RAM in use (for Windows only).

  • ML_NUM_CONNECTED_CLIENTS   The number of connected synchronization clients.

  • NUM_COMMITS   The total number of commits.

  • NUM_CONNECTED_FILE_XFERS   The number of mlfiletransfers currently connected.

  • NUM_CONNECTED_LISTENERS   The number of listeners currently connected.

  • NUM_CONNECTED_MONITORS   The number of monitors currently connected.

  • NUM_CONNECTED_PINGS   The number of pinging clients currently connected.

  • NUM_CONNECTED_SYNCS   The number of data synchronizations currently connected.

  • NUM_ERRORS   The total number of errors.

  • NUM_FAILED_SYNCS   The total number of failed syncs.

  • NUM_IN_APPLY_UPLOAD   The number of synchronizations currently in the apply upload phase.

  • NUM_IN_AUTH_USER   The number of synchronizations currently in the authenticate user phase.

  • NUM_IN_BEGIN_SYNC   The number of synchronizations currently in the begin synchronization phase.

  • NUM_IN_CONNECT   The number of synchronizations currently in the connect phase.

  • NUM_IN_CONNECT_FOR_ACK   The number of synchronizations currently in the connect for download ack phase.

  • NUM_IN_END_SYNC   The number of synchronizations currently in the end synchronization phase.

  • NUM_IN_FETCH_DNLD   The number of synchronizations currently in the fetch download phase.

  • NUM_IN_GET_DB_WORKER_FOR_ACK   The number of synchronizations currently in the get DB worker for ack phase.

  • NUM_IN_NON_BLOCKING_ACK   The number of synchronizations currently in the non-blocking download ack phase.

  • NUM_IN_PREP_FOR_DNLD   The number of synchronizations currently in the prepare for download phase.

  • NUM_IN_RECVING_UPLOAD   The number of synchronizations currently in the receive upload phase.

  • NUM_IN_SEND_DNLD   The number of synchronizations currently in the send download phase.

  • NUM_IN_SYNC_REQUEST   The number of synchronizations currently in the synchronization request phase.

  • NUM_IN_WAIT_FOR_DNLD_ACK   The number of synchronizations currently in the wait for download ack phase.

  • NUM_ROLLBACKS   The total number of rollbacks.

  • NUM_ROWS_DOWNLOADED   The total number of rows sent to remotes.

  • NUM_ROWS_UPLOADED   The total number of rows received from remotes.

  • NUM_SUCCESS_SYNCS   The total number of successful syncs.

  • NUM_UNSUBMITTED_ERROR_RPTS   The number of unsubmitted error reports.

  • NUM_UPLOAD_CONNS_IN_USE   The number of upload connections currently in use.

  • NUM_WAITING_CONS   The number of synchronizations currently waiting for the consolidated database.

  • NUM_WARNINGS   The total number of warnings.

  • PAGES_IN_STREAMSTACK   The number of pages held by the network streams.

  • PAGES_LOCKED   The number of cache pages loaded into memory.

  • PAGES_LOCKED_MAX   The number of pages in the memory cache. This is set with -cm. See -cm option.

  • PAGES_SWAPPED_IN   The total number of pages ever read from disk.

  • PAGES_SWAPPED_OUT   The total number of pages ever swapped to disk.

  • PAGES_USED   The number of cache pages used. This includes pages swapped to disk so it may be larger than the cache size.

  • RAW_TCP_STAGE_LEN   The length of the network work queue.

  • SERVER_IS_PRIMARY   Indicates if the server is primary or secondary. Shows 1 if the server is primary or 0 otherwise.

  • STREAM_STAGE_LEN   The length of the high level network processing queue.

  • TCP_BYTES_READ   The total number of bytes ever read.

  • TCP_BYTES_WRITTEN   The total number of bytes ever written.

  • TCP_CONNECTIONS   The number of TCP connections currently opened.

  • TCP_CONNECTIONS_CLOSED   The total number of connections ever closed.

  • TCP_CONNECTIONS_OPENED   The total number of connections ever opened.

  • TCP_CONNECTIONS_REJECTED   The total number of connections ever rejected.

Example

Below is sample output showing the periodic monitoring values.

I. 2008-10-14 10:34:43. <Main> PERIODIC: TCP_CONNECTIONS: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: PAGES_USED: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: PAGES_LOCKED: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: PAGES_LOCKED_MAX: 12692
I. 2008-10-14 10:34:43. <Main> PERIODIC: TCP_CONNECTIONS_OPENED: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: TCP_CONNECTIONS_CLOSED: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: TCP_CONNECTIONS_REJECTED: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: TCP_BYTES_READ: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: TCP_BYTES_WRITTEN: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: ML_NUM_CONNECTED_CLIENTS: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: PAGES_SWAPPED_OUT: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: PAGES_SWAPPED_IN: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: PAGES_IN_STREAMSTACK: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: CPU_USAGE: 468750
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_COMMITS: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_ROLLBACKS: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_SUCCESS_SYNCS: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_FAILED_SYNCS: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_ERRORS: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_WARNINGS: 1
I. 2008-10-14 10:34:43. <Main> PERIODIC: DB_CONNECTIONS: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: RAW_TCP_STAGE_LEN: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: STREAM_STAGE_LEN: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: HEARTBEAT_STAGE_LEN: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: CMD_PROCESSOR_STAGE_LEN: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_ROWS_DOWNLOADED: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_ROWS_UPLOADED: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: FREE_DISK_SPACE: 162552295424
I. 2008-10-14 10:34:43. <Main> PERIODIC: LONGEST_DB_WAIT: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: LONGEST_SYNC: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_UNSUBMITTED_ERROR_RPTS: 247
I. 2008-10-14 10:34:43. <Main> PERIODIC: MEMORY_USED: 94375936
I. 2008-10-14 10:34:43. <Main> PERIODIC: SERVER_IS_PRIMARY: 1
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_CONNECTED_SYNCS: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_CONNECTED_PINGS: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_CONNECTED_FILE_XFERS: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_CONNECTED_MONITORS: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_CONNECTED_LISTENERS: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_WAITING_CONS: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_IN_SYNC_REQUEST: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_IN_RECVING_UPLOAD: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_IN_CONNECT: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_IN_AUTH_USER: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_IN_BEGIN_SYNC: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_IN_APPLY_UPLOAD: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_IN_PREP_FOR_DNLD: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_IN_FETCH_DNLD: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_IN_END_SYNC: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_IN_SEND_DNLD: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_IN_WAIT_FOR_DNLD_ACK: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_IN_GET_DB_WORKER_FOR_ACK: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_IN_CONNECT_FOR_ACK: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_IN_NON_BLOCKING_ACK: 0
I. 2008-10-14 10:34:43. <Main> PERIODIC: NUM_UPLOAD_CONNS_IN_USE: 0
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1