Difference between revisions of "SQWareWeb:mysql"
Expdbtools (talk | contribs) |
Expdbtools (talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | {{SQWareWebPres|Mysql|mysql|instance| | + | {{SQWareWebPres|Mysql|mysql|instance|Global, databases, FS, backups| |
| − | *perf : | + | *perf : reports based on slow query |
}} | }} | ||
Latest revision as of 22:16, 18 December 2010
Presentation
Usage
It is the specific part of 'graphic' restitution of dbSQWare for Mysql.
SQWareWeb Mysql formats (graphs or tables) datas uploaded in SQWareRepository Mysql by many scripts of SQWareProduction module for Mysql.
Almost all of the data presented are dynamically generated (volumes, versions, ...),
only the data type repository or settings are stored manually in the relevant tables.
Example of static table : tsqw_Repository
Examples of pages presented for Mysql:
- Inventory of instances Mysql with volumetry, version, environnement, ...
- Distribution of instance in number/volumetry per environnement/client/version
- Detail of volumetry (Global, databases, FS, backups)
- Trace of scripts executions of SQWareProduction Mysql (beginning, end, options, duration, return code, ...)
- Performances datas
- Capacity planning
- ...
Presentation model of SQWareWeb for Mysql.
Explanation of directories
Directories located in $gvsqw_RootexpdbWebdba/htdocs/mysql :
- bin : Directory containing standard scripts
- general : Directory containing general reports for all managed instances
- detail : Directory containing contient specific report for one selected instance Mysql
- tech : Directory containing contient "technical" reports, some general and others specific per instance Mysql
- dashboard : Directory containing contient changes on instances (removed/created, patched/upgraded), and distributions
- perf : reports based on slow query
