solidDB Help : Replication : C Replicator : CREP Monitoring and diagnostics : Monitoring Replicator with pmon counters
  
Monitoring Replicator with pmon counters
The solidDB performance counters (perfmons or pmons) provide information about various database operations and performance. The performance counters are controlled with the following command, see PERFMON:
ADMIN COMMAND 'perfmon'
There are C Replicator (CREP) pmon counters in the source and target databases. The counter types in source database are Replicator and Logreader. In the target database the counter type is Replicator.
The essential replication-specific performance counters in the source database are described in the following table:
 
Logreader counter
Explanation
inserts sent
Insert operation read and sent by Logreader
updates sent
Update operations read and sent by Logreader
deletes sent
Delete operations read and sent by Logreader
commits sent
Commit operations read and sent by Logreader
pending queue len
Length of queue pending at Logreader
In addition, there are numerous other Logreader performance counters. See Using performance counters (perfmon) for more information.
The replication-specific performance counters in the target database are described in the following table:
 
Replicator Counter
Explanation
applied inserts at target database
Insert operation read and sent by replicator
applied updates at target database
Update operations read and sent by replicator
applied deletes at target database
Delete operations read and sent by replicator
number of conflicts at target database
Commit operations read and sent by replicator
rows loaded at target database
Rows loaded by initial load by replicator in target database
number of source partitions connected
Number of connected source partitions
number of tables in source partitions
Total number of tables in all connected source partitions
The following example shows the performance counter values in a source database:
solsql> admin command 'pmon -c logreader';
   RC TEXT
   -- ----
    0 Performance statistics:
    0 Time (sec)                     10   10   10   10   10   10   10   5    Total
    0 Logreader spm reqcount       : 0    0    0    0    0    0    0    0    554
    0 Logreader spm waitct         : 0    0    0    0    0    0    0    0    0
    0 Logreader spm freespc min    : 1000 1000 1000 1000 1000 1000 1000 1000 1000
    0 Logreader spm freespc max    : 1000 1000 1000 1000 1000 1000 1000 1000 1000
    0 Logreader logdata queue len  : 0    0    0    0    0    0    0    0    0
    0 Logreader record queue len   : 0    0    0    0    0    0    0    0    0
    0 Logreader open trx queue len : 0    0    0    0    0    0    0    0    0
    0 Logreader stmt queue len     : 0    0    0    0    0    0    0    0    0
    0 Logreader open cursors       : 1    1    1    1    1    1    1    1    1
    0 Logreader records processed  : 0    0    0    0    0    0    0    0    3703
    0 Logreader records sent       : 0    0    0    0    0    0    0    0    93
    0 Logreader commits processed  : 0    0    0    0    0    0    0    0    35
    0 Logreader commits sent       : 0    0    0    0    0    0    0    0    30
    0 Logreader messages sent      : 10   10   10   10   10   10   10   5    11038
    0 Logreader catchup state      : 0    0    0    0    0    0    0    0    0
    0 Logreader catchup queue len  : 0    0    0    0    0    0    0    0    0
    0 Logreader catchup queue size : 0    0    0    0    0    0    0    0    0
    0 Logreader pending queue len  : 0    0    0    0    0    0    0    0    0
    0 Logreader memcache queue len : 0    0    0    0    0    0    0    0    0
    0 Logreader batch queue len    : 1    1    1    1    1    1    1    1    1
    0 Logreader flush batch full   : 0    0    0    0    0    0    0    0    35
    0 Logreader flush batch force  : 0    0    0    0    0    0    0    0    0
    0 Logreader inserts sent       : 0    0    0    0    0    0    0    0    19
    0 Logreader updates sent       : 0    0    0    0    0    0    0    0    0
    0 Logreader deletes sent       : 0    0    0    0    0    0    0    0    4
27 rows fetched.
Go up to
CREP Monitoring and diagnostics