Smart Tables Monitoring
Administrators can monitor the Smart Tables process through 2 files:
Overview of the process (SMT_yyyy-mm-dd.csv files)
located in:
- the diagnostic ZIP file, under the
/smart_tabledirectory - the warehouse
history.dir(defined in galactica.conf), under the/smart-tablesdirectory
The system generates:
- 1 file per day
File Description
| Name | Description | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
TIME | Date and time of the action | ||||||||||||||||
ACTION | see list below
| ||||||||||||||||
| TABLE | Table Name valued only for the following Actions:
| ||||||||||||||||
| Comments |
|
Results of the analysis process (smart_indexes.csv files)
located in:
- the diagnostic ZIP file, under the
/smart_table_logdirectory - the warehouse, under the
My_schema.db/My_table/analysis/ directory
The system generates:
- 1 file per table (No split per day)
When the table is dropped, so is the related smart_indexes file.
| Name | Description | Values |
|---|---|---|
| DATE | Date of the end of the table analysis | Timestamp |
| TYPE | Process who did the analysis | Constant: SMART |
| STATUS | Index status: existing one, new one, or not used anymore | EXISTING, NEW, OUTDATED |
| NAME | Name of the index (for existing indexes) | |
| MAIN | Is the index a MAIN index or not? | false/true |
| HITS | Number of hits | long |
| SIZE | Size of the index (for existing indexes) | long |
| COUNT | Number of rows in the index (for existing indexes) | long |
| BEWARE | Parameter of the analysis, see Indexima Analyser page for more details | |
| SPEC | Parameter of the analysis, see Indexima Analyser page for more details | |
| PREJOIN | Parameter of the analysis, see Indexima Analyser page for more details | |
| TUNING | Parameter of the analysis, see Indexima Analyser page for more details | |
| ACTION | Parameter of the analysis, see Indexima Analyser page for more details | |
| MIN_HIT | Parameter of the analysis, see Indexima Analyser page for more details | |
| COEF_MERGE | Parameter of the analysis, see Indexima Analyser page for more details | |
| NB_DAYS | Parameter of the analysis, see Indexima Analyser page for more details | |
| FIELDS | Fields of the new index Ex: Year(Date),sum(Turnover) | |
| JOINS | Join clause (if there is any) of the new index Ex: JOIN mytble2 on XX.field1=mytble2.field2 | |
| MERGE_STRATEGY | Parameter of the analysis, see Indexima Analyser page for more details | |
| MAX_EXPECTED_INDEXES | Parameter of the analysis, see Indexima Analyser page for more details |