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

Monitoring

Concept

Monitorting is an approach to monitor the status of current system. In SequoiaDB, users can monitor system with SNAPSHOT command and LIST command.

Note: If the query is a snapshot in a clustered environment, you can get connected to the coordinator node.

Corrdinator node connections, the default is to get a snapshot of the entire cluster of information, for example: snapshot(SDB_SNAP_SYSTEM)

To obtain the specified partition group snapshot information, using criteria query, for example: snapshot(SDB_SNAP_SYSTEM,{ GroupName: "group1" } )

To get a snapshot of the information specified node, using criteria query, for example: snapshot(SDB_SNAP_SYSTEM,{ HostName: "host1", svcname: "11820' } )

Snapshot

Snapshot is a kind of command which can get the current status of system. There are different types of snapshots as follow:

Snapshot Sign Snapshot Type Description
SDB_SNAP_CONTEXTS Context Context snapshot contains all the contexts corresponding to all the sessions in current data node.
SDB_SNAP_CONTEXTS_CURRENT Context of current session Current contexts snapshot contains the session contexts corresponding to current connections in data nodes.
SDB_SNAP_SESSIONS Session Session snapshot contains all the sessions between users and system on current database node.
SDB_SNAP_SESSIONS_CURRENT Current session Current session snapshot contains the current sessions on current database node.
SDB_SNAP_COLLECTIONS Collection Collections snapshot contains all the non-temporary collections in current data nodes or current cluster.
SDB_SNAP_COLLECTIONSPACES Collection space Collection space snapshot contains all the collection space in the current data node or cluster. (expect from catalog collection space)
SDB_SNAP_DATABASE Database Database snapshot contains database monitoring information of current database node.
SDB_SNAP_SYSTEM System System snapshot contains system monitoring information of current database node.
SDB_SNAP_CATALOG Catalog information View catalog information for.

List

List is a kind of lightweight command for getting system current status.There are different types of lists as follow:

List Sign List Type Description
SDB_LIST_CONTEXTS Context Context list contains all the contexts corresponding to all the sessions in current data node.
SDB_LIST_CONTEXTS_CURRENT Context of current session Current contexts list contains the session contexts corresponding to current connections in data nodes.
SDB_LIST_SESSIONS Session Session list contains all the sessions between users and system on current database node.
SDB_LIST_SESSIONS_CURRENT Current session Current session list contains the current sessions on current database node.
SDB_LIST_COLLECTIONS Collection Collections list contains all the non-temporary collections in current data nodes or current cluster.
SDB_LIST_COLLECTIONSPACES Collection space Collection space snapshot contains all the collection space in the current data node or current cluster. (expect from catalog collection space)
SDB_LIST_STORAGEUNITS Storage unit Storage unit list contains information of all storage units on current database node.
SDB_LIST_GROUPS Replica Group Replica Group list contains infromation of all shards in current cluster.
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