SQWareRepository:mysql: Difference between revisions
Jump to navigation
Jump to search
Replaced content with '{{SQWareRepositoryPresSgbd|Mysql|database|instances|mys}} == Specific database content for MySQL ==' |
No edit summary |
||
Line 1: | Line 1: | ||
{{SQWareRepositoryPresSgbd|Mysql|database|instances|mys}} | {{SQWareRepositoryPresSgbd|Mysql|database|instances|mys}} | ||
== Specific database content for MySQL == | == Specific database content for MySQL == | ||
{{SQWareRepositoryTables|tsqwmys_LogSlowQuery| | |||
<nowiki>...</nowiki>| | |||
<pre> | |||
Field Type | |||
dbalias varchar(80) | |||
gather_date datetime | |||
status varchar(30) | |||
longquerytime int(11) | |||
log_file varchar(800) | |||
</pre> | |||
}} | |||
{{SQWareRepositoryTables|tsqwmys_Parameters| | |||
<nowiki>...</nowiki>| | |||
<pre> | |||
Field Type | |||
dbalias varchar(80) | |||
gather_date datetime | |||
name varchar(255) | |||
value varchar(4000) | |||
</pre> | |||
}} | |||
{{SQWareRepositoryTables|tsqwmys_VolDb| | |||
<nowiki>...</nowiki>| | |||
<pre> | |||
Field Type | |||
dbalias varchar(80) | |||
database_name varchar(255) | |||
gather_date datetime | |||
size_db decimal(12,2) | |||
</pre> | |||
}} | |||
{{SQWareRepositoryTables|tsqwmys_VolTables| | |||
<nowiki>...</nowiki>| | |||
<pre> | |||
Field Type | |||
dbalias varchar(80) | |||
gather_date datetime | |||
table_schema varchar(64) | |||
table_name varchar(64) | |||
engine varchar(64) | |||
table_rows int(11) | |||
data_length decimal(12,2) | |||
index_length decimal(12,2) | |||
</pre> | |||
}} |
Latest revision as of 19:13, 8 August 2015
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 tsqwmys_% or isqwmys_% are specific for Mysql.
Installation guide for SQWareRepository for Mysql
Naming convention
All specific objects for Mysql are named with prefixes:
- tsqwmys_% : for tables
- isqwmys_% : for index
- isqwmys_%_u : for uniques
- isqwmys_%_pk : for primary key
Specific database content for MySQL
tsqwmys_LogSlowQuery
This table contains :
...
Desc of tsqwmys_LogSlowQuery :
Field Type dbalias varchar(80) gather_date datetime status varchar(30) longquerytime int(11) log_file varchar(800)
tsqwmys_Parameters
This table contains :
...
Desc of tsqwmys_Parameters :
Field Type dbalias varchar(80) gather_date datetime name varchar(255) value varchar(4000)
tsqwmys_VolDb
This table contains :
...
Desc of tsqwmys_VolDb :
Field Type dbalias varchar(80) database_name varchar(255) gather_date datetime size_db decimal(12,2)
tsqwmys_VolTables
This table contains :
...
Desc of tsqwmys_VolTables :
Field Type dbalias varchar(80) gather_date datetime table_schema varchar(64) table_name varchar(64) engine varchar(64) table_rows int(11) data_length decimal(12,2) index_length decimal(12,2)