Difference between revisions of "SQWareRepository:mysql"
Expdbtools (talk | contribs) (Replaced content with '{{SQWareRepositoryPresSgbd|Mysql|database|instances|mys}} == Specific database content for MySQL ==') |
Expdbtools (talk | contribs) |
||
| 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
Contents
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)
