SQWareRepository:mongodb

From wiki_dbSQWare_3.1
Jump to: navigation, search

Presentation

It is the repository module, and stores rdbms indicators for all RDBMS.
It is a MySQL database.
Objects prefix by tsqw_% or isqw_% are generic.
Objects prefix by tsqwmng_% or isqwmng_% are specific for MongoDB.
Installation guide for SQWareRepository™ for MongoDB

Naming convention

All specific objects for MongoDB are named with prefixes:

  • tsqwmng_% : for tables
  • isqwmng_% : for index
  • isqwmng_%_u : for uniques
  • isqwmng_%_pk : for primary key


Nuvola apps important.png
Warning:
Do not change the standard tables of the tool. For your custom objects, use another name convention than dbSQWare.

This will facilitate version upgrades.


Specific database content for MongoDB

tsqwmng_InstanceDetail

This table contains : ...
Desc of tsqwmng_InstanceDetail :

Field Type
dbalias varchar(80)
nodename varchar(80)
gather_date datetime
size_instance decimal(12,2)
used decimal(12,2)
free decimal(12,2)
maj_version int(11)
version varchar(30)


tsqwmng_Parameters

This table contains : ...
Desc of tsqwmng_Parameters :

Field Type
dbalias varchar(80)
nodename varchar(80)
gather_date datetime
name varchar(255)
value varchar(255)


tsqwmng_VolDb

This table contains : ...
Desc of tsqwmng_VolDb :

Field Type
dbalias varchar(80)
nodename varchar(80)
database_name varchar(255)
gather_date datetime
dataSize decimal(12,2)
storageSize decimal(12,2)
fileSize decimal(12,2)
collections decimal(12,2)
indexSize decimal(12,2)
indexes decimal(12,2)


tsqwmng_VolTables

This table contains : ...
Desc of tsqwmng_VolTables :

Field Type
dbalias varchar(80)
nodename varchar(80)
gather_date datetime
database_name varchar(255)
table_name varchar(255)
table_count decimal(12,2)
table_size decimal(12,2)
storageSize decimal(12,2)
nindexes decimal(12,2)
totalIndexSize decimal(12,2)