v1.10

Document

How to Start SequoiaDB

Basic Operation

Data Model

Database Management

Aggregation

Index

Replication

Cluster

Connector

Reference

Development

Release Note

FAQ

  • Content
  • Comments
  • History

Analyzing Text

sdbtop is a performance monitoring tool of SequoiaDB. The information of each node in the cluster can be monitored and checked by this tool.

Options

Parameters Abbr Description
--help -h return basic help and usage documents.
--confpath -c the configuration file of sdbtop, both the UI and output fields of sdbtop depends on this file(default configurations will be used if configuration file is not given by the user)
--hostname -i specify the host name of the server to be monitored
--servicename -s specify the service name of the port to be monitored
--usrname -u database user name
--password -p database password
Note: For Ubuntu and other systems, you need to install Ncurses library, Or it will shows 'Error opening terminal: TERM' Solution1: online installing
sudo apt-get install libncurses5-dev
Solution2: Source code installing. Deco mpress tar -xvzf ncurses-5.5.tar.gz and enter ncurses-5.5 content
./configure
sudo make && make install

Usage

In the following example, sdbtop uses "/opt/sequoiadb/conf/sdbtop.xml" as the configuration file, it monitors one node in a server named sdbserver3 on the port in a service name of 11810, using test as both the user name and password.

sdbtop -c /opt/sequoiadb/conf/sdbtop.xml -i sdbserver3 -s 11810 -u test -p test

Then enter the main window:

refresh= 3 secs                             sdbtop 1.0                        snapshotMode: GLOBAL
displayMode: ABSOLUTE                      Main Window                     snapshotModeInput: NULL
hostname: sdbserver3                                                           filtering Number: 0
servicename: 11810                                             sortingWay: NULL sortingField: NULL
usrName: test                                                        Refresh: F5, Quit: q, Help: h
 #####  ######  ######  #######  #####  ######   For help type h or ...
#       #     # #     #    #    #     # #     #  sdbtop -h: usage
#       #     # #     #    #    #     # #     #
 #####  #     # ######     #    #     # ######
      # #     # #     #    #    #     # #
      # #     # #     #    #    #     # #
 #####  ######  ######     #     #####  #
SDB Interactive Snapshot Monitor V2.0
Use these keys to navigate:
  m   -  Main Window            s   -  Sessions               c   -  CollectionSpaces
  t   -  System                 d   -  Database               G   -  GLOBAL_SNAPSHOT
  g   -  GROUP_SNAPSHOT         n   -  NODE_SNAPSHOT          r   -  reset refreshInterval
  A   -  Ascending order        D   -  Descending order       C   -  filter condition
  Q   -  no filter condition    N   -  filter number          W   -  no filter number
Licensed Materials - Property of SequoiaDB
Copyright SequoiaDB Corp. 2013-2014 All Rights Reserved.
Note: all the supported keys can be checked by pressing 'h' in the main window
  • Main window keys usage:

    Parameters Description
    m return to main window
    s list all the sessions f the node
    c list all the collection spaces of the node
    t list the status of resource usage of the node
    d list the monitoring information of the node
    G global_snapshot, monitor all the data node groups
    g group_snapshot, specify the data node group to be monitored
    n node_snapshot, list all the monitoring information of the specified databse node
    r set the time interval of screen refreshing in seconds
    A sort the monitoring information in ascending order
    D sort the monitoring information in descending order
    C filter the monitoring information by certain conditions
    Q return the information without filtering by the conditions
    N skip the information with certain line number
    W return the information without filtering by the line number
    h check the help document
    Esc cancel the current operation
    Enter return to the last monitoring user interface
    F5 forces the background monitoring information to refresh
    < move to left to check the hided monitoring information in the left column
    > move to right to check the hided monitoring information in the right column
    q quit the program
    Tab change the data computing mode(absolute value, avg. value, difference)
  • Example 1:

    1. After entering the main window, press key 's' to list all the session information of the nodes.

    refresh= 3 secs                             sdbtop 1.0                        snapshotMode: GLOBAL
    displayMode: ABSOLUTE                        Sessions                      snapshotModeInput: NULL
    hostname: sdbserver3                                                           filtering Number: 0
    servicename: 11810                                             sortingWay: NULL sortingField: NULL
    usrName: test                                                        Refresh: F5, Quit: q, Help: h
         SessionID                           TID Type               Name
         ------------------------------ -------- ------------------ ------------------------------
      1  sdbserver3:11820:1                10732 LogWriter          ""
      2  sdbserver3:11820:10               10741 Task               Job[Prefetcher]
      3  sdbserver3:11820:11               10742 Task               Job[Prefetcher]
      4  sdbserver3:11820:12               10743 Task               Job[Prefetcher]
      5  sdbserver3:11820:13               10744 Cluster            ""
      6  sdbserver3:11820:14               10745 ClusterShard       ""
      7  sdbserver3:11820:15               10746 ClusterLogNotify   ""
      8  sdbserver3:11820:16               10747 ShardReader        ""
      9  sdbserver3:11820:17               10748 ReplReader         ""
     10  sdbserver3:11820:18               10749 SyncClockWorker    ""
     11  sdbserver3:11820:19               10750 TCPListener        ""
     12  sdbserver3:11820:2                10733 DpsRollback        ""
     13  sdbserver3:11820:20               10751 RestListener       ""
     14  sdbserver3:11820:21               10752 Task               Job[PageCleaner]
     15  sdbserver3:11820:3                10734 Task               Job[Prefetcher]
     16  sdbserver3:11820:4                10735 Task               Job[Prefetcher]
     17  sdbserver3:11820:42               10847 ReplAgent          NodeID:1000,TID:1,Start:active
     18  sdbserver3:11820:5                10736 Task               Job[Prefetcher]
     19  sdbserver3:11820:59               23263 ShardAgent         NetID:1,TID:23262
     20  sdbserver3:11820:6                10737 Task               Job[Prefetcher]
     21  sdbserver3:11820:7                10738 Task               Job[Prefetcher]
     22  sdbserver3:11820:8                10739 Task               Job[Prefetcher]

    2. Press 'Tab', the value of the 'displayMode' on the upper corner of the screen will change.

    3. Press 'r', enter '2' at the bottom of the screen to set the refresh time interval. The value of the 'refresh' on the upper corner of the screen will change to 2.

    refresh= 2 secs                        sdbtop 1.0                    snapshotMode: GLOBAL
    displayMode: ABSOLUTE                  Sessions                      snapshotModeInput: NULL
    hostname: sdbserver3                                                 filtering Number: 0
    servicename: 11810                                             sortingWay: NULL sortingField: NULL
    usrName: test                                                        Refresh: F5, Quit: q, Help: h
         SessionID                           TID Type               Name
         ------------------------------ -------- ------------------ ------------------------------
      1  sdbserver3:11820:1                10732 LogWriter          ""
      2  sdbserver3:11820:10               10741 Task               Job[Prefetcher]
      3  sdbserver3:11820:11               10742 Task               Job[Prefetcher]
      4  sdbserver3:11820:12               10743 Task               Job[Prefetcher]
      5  sdbserver3:11820:13               10744 Cluster            ""
      6  sdbserver3:11820:14               10745 ClusterShard       ""
      7  sdbserver3:11820:15               10746 ClusterLogNotify   ""
      8  sdbserver3:11820:16               10747 ShardReader        ""
      9  sdbserver3:11820:17               10748 ReplReader         ""
     10  sdbserver3:11820:18               10749 SyncClockWorker    ""
     11  sdbserver3:11820:19               10750 TCPListener        ""
     12  sdbserver3:11820:2                10733 DpsRollback        ""
     13  sdbserver3:11820:20               10751 RestListener       ""
     14  sdbserver3:11820:21               10752 Task               Job[PageCleaner]
     15  sdbserver3:11820:3                10734 Task               Job[Prefetcher]
     16  sdbserver3:11820:4                10735 Task               Job[Prefetcher]
     17  sdbserver3:11820:42               10847 ReplAgent          NodeID:1000,TID:1,Start:active
     18  sdbserver3:11820:5                10736 Task               Job[Prefetcher]
     19  sdbserver3:11820:59               23263 ShardAgent         NetID:1,TID:23262
     20  sdbserver3:11820:6                10737 Task               Job[Prefetcher]
     21  sdbserver3:11820:7                10738 Task               Job[Prefetcher]
     22  sdbserver3:11820:8                10739 Task               Job[Prefetcher]

    4. Press 'A' and enter 'TID', the result list will be sorted according to TID.

    refresh= 2 secs                             sdbtop 1.0                        snapshotMode: GLOBAL
    displayMode: ABSOLUTE                        Sessions                      snapshotModeInput: NULL
    hostname: sdbserver3                                                           filtering Number: 0
    servicename: 11810                                             sortingWay: NULL sortingField: NULL
    usrName: test                                                        Refresh: F5, Quit: q, Help: h
         SessionID                           TID Type               Name
         ------------------------------ -------- ------------------ ------------------------------
      1  sdbserver3:11820:1                10732 LogWriter          ""
      2  sdbserver3:11820:10               10741 Task               Job[Prefetcher]
      3  sdbserver3:11820:11               10742 Task               Job[Prefetcher]
      4  sdbserver3:11820:12               10743 Task               Job[Prefetcher]
      5  sdbserver3:11820:13               10744 Cluster            ""
      6  sdbserver3:11820:14               10745 ClusterShard       ""
      7  sdbserver3:11820:15               10746 ClusterLogNotify   ""
      8  sdbserver3:11820:16               10747 ShardReader        ""
      9  sdbserver3:11820:17               10748 ReplReader         ""
     10  sdbserver3:11820:18               10749 SyncClockWorker    ""
     11  sdbserver3:11820:19               10750 TCPListener        ""
     12  sdbserver3:11820:2                10733 DpsRollback        ""
     13  sdbserver3:11820:20               10751 RestListener       ""
     14  sdbserver3:11820:21               10752 Task               Job[PageCleaner]
     15  sdbserver3:11820:3                10734 Task               Job[Prefetcher]
     16  sdbserver3:11820:4                10735 Task               Job[Prefetcher]
     17  sdbserver3:11820:42               10847 ReplAgent          NodeID:1000,TID:1,Start:active
     18  sdbserver3:11820:5                10736 Task               Job[Prefetcher]
     19  sdbserver3:11820:59               23263 ShardAgent         NetID:1,TID:23262
     20  sdbserver3:11820:6                10737 Task               Job[Prefetcher]
     21  sdbserver3:11820:7                10738 Task               Job[Prefetcher]
     please input the displayName which need order by asc : TID

    5. Press 'N' and enter 1, the returned list will skip the record with a line number of 1.

    6. Press 'W', the list will be returned without filtered by any line numbers.

    7. Press 'C' and enter 'TID: 10732' to filter the result set, only the record with the a TID of 10732 will be returned.

    refresh= 2 secs                             sdbtop 1.0                        snapshotMode: GLOBAL
    displayMode: ABSOLUTE                        Sessions                      snapshotModeInput: NULL
    hostname: sdbserver3                                                           filtering Number: 0
    servicename: 11810                                             sortingWay: NULL sortingField: NULL
    usrName: test                                                        Refresh: F5, Quit: q, Help: h
         SessionID                           TID Type               Name
         ------------------------------ -------- ------------------ ------------------------------
      1  sdbserver3:11820:1                10732 LogWriter          ""
      2  sdbserver3:11820:10               10741 Task               Job[Prefetcher]
      3  sdbserver3:11820:11               10742 Task               Job[Prefetcher]
      4  sdbserver3:11820:12               10743 Task               Job[Prefetcher]
      5  sdbserver3:11820:13               10744 Cluster            ""
      6  sdbserver3:11820:14               10745 ClusterShard       ""
      7  sdbserver3:11820:15               10746 ClusterLogNotify   ""
      8  sdbserver3:11820:16               10747 ShardReader        ""
      9  sdbserver3:11820:17               10748 ReplReader         ""
     10  sdbserver3:11820:18               10749 SyncClockWorker    ""
     11  sdbserver3:11820:19               10750 TCPListener        ""
     12  sdbserver3:11820:2                10733 DpsRollback        ""
     13  sdbserver3:11820:20               10751 RestListener       ""
     14  sdbserver3:11820:21               10752 Task               Job[PageCleaner]
     15  sdbserver3:11820:3                10734 Task               Job[Prefetcher]
     16  sdbserver3:11820:4                10735 Task               Job[Prefetcher]
     17  sdbserver3:11820:42               10847 ReplAgent          NodeID:1000,TID:1,Start:active
     18  sdbserver3:11820:5                10736 Task               Job[Prefetcher]
     19  sdbserver3:11820:59               23263 ShardAgent         NetID:1,TID:23262
     20  sdbserver3:11820:6                10737 Task               Job[Prefetcher]
     21  sdbserver3:11820:7                10738 Task               Job[Prefetcher]
     please input the filter condition : TID:10732

    8. Press 'Q' to return the list without filtered by filtering by the conditions.

    9. Press '<' or '>' to check the information hided in the left or right columns.

please login to comment.
Latest Comment
  • 2015-02-14

About Us

SequoiaDB is a financial-level distributed database vendor and is the first Chinese database listed in Gartner’s Magic Quadrant OPDBMS report. SequoiaDB has recently released version 3.0.
SequoiaDB is now penetrating the vertical sector Financial Industry quickly and had more than 50 banking clients and hundreds of enterprise customers in industries including government, telecommunication, Internet and IoT.

Beijing:
Tower R, No.8 North Star East Road, Chaoyang District, Beijing,China
Guangzhou:
Tower A, No.22 Qinglan Street, Panyu District, Guangzhou,China
Shenzhen:
Tsing Hua Tech Park, Nanshan District, Shenzhen,China
Tel:400-8038-339
E-mail:contact@sequoiadb.com