1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
|
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Displaying Replication Statistics</title>
<link rel="stylesheet" href="gettingStarted.css" type="text/css" />
<meta name="generator" content="DocBook XSL Stylesheets V1.73.2" />
<link rel="start" href="index.html" title="Getting Started with the Oracle Berkeley DB SQL APIs" />
<link rel="up" href="sqlrep.html" title="Chapter 4. Using Replication with the SQL API" />
<link rel="prev" href="reppragma.html" title="Replication PRAGMAs" />
<link rel="next" href="rep_usageexamples.html" title="Replication Usage Examples" />
</head>
<body>
<div xmlns="" class="navheader">
<div class="libver">
<p>Library Version 11.2.5.3</p>
</div>
<table width="100%" summary="Navigation header">
<tr>
<th colspan="3" align="center">Displaying Replication Statistics</th>
</tr>
<tr>
<td width="20%" align="left"><a accesskey="p" href="reppragma.html">Prev</a> </td>
<th width="60%" align="center">Chapter 4. Using Replication with the SQL API</th>
<td width="20%" align="right"> <a accesskey="n" href="rep_usageexamples.html">Next</a></td>
</tr>
</table>
<hr />
</div>
<div class="sect1" lang="en" xml:lang="en">
<div class="titlepage">
<div>
<div>
<h2 class="title" style="clear: both"><a id="repstatistics"></a>Displaying Replication Statistics</h2>
</div>
</div>
</div>
<p>
You can display a brief summary of replication statistics
using <code class="literal">.stat :rep:</code>. This
command displays the most basic information about
replication status, as well as some information that is
useful for troubleshooting.
</p>
<pre class="programlisting">dbsql> .stat :rep:
Replication summary statistics
Environment configured as a replication client
Startup complete
1/50232 Maximum permanent LSN
2 Number of environments in the replication group
0 Number of failed message sends
0 Number of messages ignored due to pending recovery
0 Number of log records currently queued </pre>
<p>
In the above output:
</p>
<div class="itemizedlist">
<ul type="disc">
<li>
<p>
<code class="literal">Environment configured as a replication client</code>
</p>
<p>
Identifies the current role of the site within the
replication group. In this example, the current
site is not the master site. <span class="emphasis"><em>Replication
client</em></span> is another term for
<span class="emphasis"><em>replica</em></span>.
</p>
</li>
<li>
<p>
<code class="literal">Startup complete</code>
</p>
<p>
Indicates that this replica site has completed its
synchronization with the master site. Replica
synchronization can take some time if there are
many master transactions with which it needs to
catch up.
</p>
</li>
<li>
<p>
<code class="literal">Maximum permanent LSN</code>
</p>
<p>
Identifies the most recent log record that is
durably replicated on a master or acknowledged by a
replica. You can compare a replica's maximum
permanent LSN to the master's maximum permanent LSN
to determine if the replica is caught up with the
master.
</p>
</li>
<li>
<p>
<code class="literal">Number of failed message sends</code>
</p>
<p>
If this number is increasing, it could be an
indication of network or communications problems
between sites in the replication group.
</p>
</li>
<li>
<p>
<code class="literal">Number of messages ignored due to pending recovery</code>
</p>
<p>
If this number is increasing, this site is ignoring
messages because it is starting up or recovering
and may need some time to catch up with the rest of
the replication group.
</p>
</li>
<li>
<p>
<code class="literal">Number of log records currently queued</code>
</p>
<p>
If this number is increasing, it means that
connections to other sites may be unavailable or
congested and that there may be delays in durably
replicating master transactions.
</p>
</li>
</ul>
</div>
</div>
<div class="navfooter">
<hr />
<table width="100%" summary="Navigation footer">
<tr>
<td width="40%" align="left"><a accesskey="p" href="reppragma.html">Prev</a> </td>
<td width="20%" align="center">
<a accesskey="u" href="sqlrep.html">Up</a>
</td>
<td width="40%" align="right"> <a accesskey="n" href="rep_usageexamples.html">Next</a></td>
</tr>
<tr>
<td width="40%" align="left" valign="top">Replication PRAGMAs </td>
<td width="20%" align="center">
<a accesskey="h" href="index.html">Home</a>
</td>
<td width="40%" align="right" valign="top"> Replication Usage Examples</td>
</tr>
</table>
</div>
</body>
</html>
|
