Oninit cdi / Archive
Talk to an expert →

output of cdr stats rec

Posted in 2015

Topics: High Availability & Replication

FRANK — — source: IIUG Forums & Mailing Lists

Can some one explain the line form the doc example, , Server Repl Txn Ins Del Upd Last Target Apply Last Source Commit 144 9371650 11 0 0 220 2005/03/30 09:36:25 2005/03/30 09:36:25 Txn column is 11, but Upd column is 220. What does 220 mean? ( number of transactions? if yes, it should be less than 11 ?) Thanks Frank Examples The following output is an example of the *cdr stats recv* command: cdr stats recv Receive Parallelism Statistics Server Tot.Txn. Pending Active MaxPnd MaxAct AvgPnd AvgAct CommitRt 144 11 0 0 3 2 1.27 1.36 0.01 Tot Pending:0 Tot Active:0 Avg Pending:0.00 Avg Active:0.00 Avg Commit Rate:0.01 Statistics by Source Server Repl Txn Ins Del Upd Last Target Apply Last Source Commit 144 9371650 11 0 0 220 2005/03/30 09:36:25 2005/03/30 09:36:25 --001a11353fc6df8e95051b8c743f

↪ replying to FRANK
Link, David A — — source: IIUG Forums & Mailing Lists

Frank, You had 11 transactions and 220 row updates. Guessing 20 rows/transaction? -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FRANK Sent: Thursday, July 23, 2015 10:23 AM To: ids@iiug.org Subject: output of cdr stats rec [35516] Can some one explain the line form the doc example, , Server Repl Txn Ins Del Upd Last Target Apply Last Source Commit 144 9371650 11 0 0 220 2005/03/30 09:36:25 2005/03/30 09:36:25 Txn column is 11, but Upd column is 220. What does 220 mean? ( number of transactions? if yes, it should be less than 11 ?) Thanks Frank Examples The following output is an example of the *cdr stats recv* command: cdr stats recv Receive Parallelism Statistics Server Tot.Txn. Pending Active MaxPnd MaxAct AvgPnd AvgAct CommitRt 144 11 0 0 3 2 1.27 1.36 0.01 Tot Pending:0 Tot Active:0 Avg Pending:0.00 Avg Active:0.00 Avg Commit Rate:0.01 Statistics by Source Server Repl Txn Ins Del Upd Last Target Apply Last Source Commit 144 9371650 11 0 0 220 2005/03/30 09:36:25 2005/03/30 09:36:25 --001a11353fc6df8e95051b8c743f ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to FRANK
Madison Pruet — — source: IIUG Forums & Mailing Lists

See Below From: "FRANK" <yunyaoqu@gmail.com> To: ids@iiug.org Date: 07/23/2015 10:23 AM Subject: output of cdr stats rec [35516] Sent by: ids-bounces@iiug.org Can some one explain the line form the doc example, , Server Repl Txn Ins Del Upd Last Target Apply Last Source Commit 144 9371650 11 0 0 220 2005/03/30 09:36:25 2005/03/30 09:36:25 Txn column is 11, but Upd column is 220. What does 220 mean? ( number of transactions? if yes, it should be less than 11 ?) INS, DEL and UPD are the number of rows affected by the 11 transactions. <<<=3D=3D=3D Thanks Frank Examples The following output is an example of the *cdr stats recv* command: cdr stats recv Receive Parallelism Statistics Server Tot.Txn. Pending Active MaxPnd MaxAct AvgPnd AvgAct CommitRt 144 11 0 0 3 2 1.27 1.36 0.01 Tot Pending:0 Tot Active:0 Avg Pending:0.00 Avg Active:0.00 Avg Commit Rate:0.01 Statistics by Source Server Repl Txn Ins Del Upd Last Target Apply Last Source Commit 144 9371650 11 0 0 220 2005/03/30 09:36:25 2005/03/30 09:36:25 --001a11353fc6df8e95051b8c743f ***************************************************************************= **** Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary