M$SYS_TABLE_PROPERTY
Displays table property information applied to each table.
| 컬럼 이름 | 설명 |
|---|---|
| ID | Table identifier |
| NAME | Property Name |
| VALUE | Property Value |
M$SYS_COLUMNS
Displays the column information of the user table displayed in M$SYS_TABLES.
Column Name | Description |
|---|---|
| NAME | Column name |
| TYPE | Column type |
| DATABASE_ID | Database identifier |
| ID | Column identifier |
| LENGTH | Column length |
| TABLE_ID | Table identifier of column |
| FLAG | (Information for internal use of the server) |
| PART_PAGE_COUNT | Pages per partition |
| PAGE_VALUE_COUNT | Number of data per page |
| MINMAX_CACHE_SIZE | Size of MIN-MAX cache |
| MAX_CACHE_PART_COUNT | Maximum number of partition caches |
M$SYS_INDEXES
Displays the index information generated by the user.
Column Name | Description |
|---|---|
| NAME | Index name |
| TYPE | Index type |
| DATABASE_ID | Database identifier |
| ID | Index identifier |
| TABLE_ID | Table of index identifier |
| COLCOUNT | Number of columns of created index |
| PART_VALUE_COUNT | Number of data per partition of index table |
| BLOOM_FILTER | Availability of Bloom Filter |
| KEY_COMPRESS | Compression status of key values |
| MAX_LEVEL | Maximum level of index (LSM only) |
| PAGE_SIZE | Page size |
| MAX_KEYWORD_SIZE | Maximum keyword length (keyword only) |
| BITMAP_ENCODE | Bitmap encoding type (RANGE / EQUAL) |
M$SYS_INDEX_COLUMNS
Displays the column information of the user index shown in M$SYS_INDEXES.
Column Name | Description |
|---|---|
| INDEX_ID | Index identifier |
| INDEX_TYPE | Index type |
| NAME | Column name |
| COL_ID | Column identifier |
| DATABASE_ID | Database identifier |
| TABLE_ID | Table identifier |
| TYPE | Data type of column |
M$SYS_TABLESPACES
Displays the table space information created by the user.
Column Name | Description |
|---|---|
| NAME | Tablespace name |
| ID | Tablespace identifier |
| DISK_COUNT | Number of disks in tablespace |
M$SYS_TABLESPACE_DISKS
Maintains the disk information used by the tablespace.
Column Name | Description |
|---|---|
| NAME | Disk name |
| ID | Disk identifier |
| TABLESPACE_ID | Disk tablespace identifier |
| PATH | Disk path |
| IO_THREAD_COUNT | Number of IO threads allocated to this disk |
| VIRTUAL_DISK_COUNT | Number of Virtual Disk units assigned to this disk |
M$SYS_USERS
Maintain user information registered in Machbase.
Column Name | Description |
|---|---|
| USER_ID | User identifier |
| NAME | User name |
Collectors
M$SYS_COLLECTORS
Displays the collector information registered in the Machbase server.
Column Name | Description |
|---|---|
| COLLECTOR_ID | Collector identifier |
| COLLECTOR_NAME | Collector name |
| TABLE_NAME | Name of table where Collector will enter data |
| TEMPLATE_NAME | Template file name |
| COLLECTOR_TYPE | Collector type |
| COLLECTOR_SOURCE | Input log file location |
| COLLECTOR_LIB | Input library name |
| COL_COUNT | Number of columns |
| PREPROCESS_PATH | Preprocessor file path |
| REGEX_PATH | Regular Expression file path |
| REGEX | Regular Expression |
| END_REGEX | Signifies end of regular expression |
| LANGUAGE | Log file language setting (UTF-8) |
| SLEEP_TIME | Collector input cycle |
| DB_ADDR | Machbase server IP address |
| DB_PORT | Machbase server port |
| DB_USER | Database user name |
| DB_PASS | Database user password |
| PROCESS_BYTE | Data size input at once (reset upon re-input) |
| PROCESS_RECORD | Number of data records input at once (reset upon re-input) |
| TOTAL_PROCESS_BYTE | Total size of input data after startup |
| TOTAL_PROCESS_RECORD | Total number of data records input after startup |
| LAST_PROCESS_TIME | Last input time |
| RUN_FLAG | Collector run status (0:STOP, 1:START) |
M$SYS_COLLECTOR_COLUMNS
Displays the column information of the table entered by the collector.
Column Name | Description |
|---|---|
| COLLECTOR_ID | Collector identifier |
| COL_ID | Column identifier |
| NAME | Column name |
| TYPE_NAME | Column data type |
| DATE_FORMAT | Converted string format when datatype is Datetime |
| TYPE_CODE | Column data type code |
| SIZE | Column length |
| USE_INDEX | Index in use status |
| REGEX_NO | Number of registered regular expressions |
M$SYS_COLLECTOR_OFFSETS
Displays the last offset information of the table entered by the collector and the source checksum at that time.
| Info |
|---|
Available from version 5.5. In the previous version, the offset information stored in the table was directly inquired. However, since 5.5, the information is continually managed in the memory. |
Column Name | Description |
|---|---|
| USER_NAME | User name |
| TABLE_NAME | Table name |
| ADDRESS | Collector location |
| CHECKSUM1 | Collector Source Checksum 1 |
| CHECKSUM2 | Collector Source Checksum 2 |
| OFFSET | Collector Source Offset |
M$SYS_COLLECTORMANAGERS
Displays the Collector manager information managing the Collector.
Column Name | Description |
|---|---|
| MANAGER_ID | Collector manager identifier |
| MANAGER_NAME | Collector manager name |
| MANAGER_HOST | Collector manager host |
| MANAGER_PORT | Collector manager port number |
| MANAGER_LAST_PROCESS_TIME | Last process time of collector manager |
M$SYS_COLLECTOR_SOURCES
Displays the format of the source that the Collector collects. This source is managed by the Collector manager.
Column Name | Description |
|---|---|
| MANAGER_ID | Collector manager identifier |
| MANAGER_NAME | Collector manager name |
| SOURCE_TYPE | Log file type |
| SOURCE_PATH | Log file location path |
| CONTEXT |
Others
M$TABLES
Display all meta tables beginning with M$.
Column Name | Description |
|---|---|
| NAME | Meta table name |
| TYPE | Table type |
| DATABASE_ID | Database identifier |
| ID | Meta table identifier |
| USER ID | Table user (in this case, SYS) |
| COLCOUNT | Number of columns |
M$COLUMNS
Displays the column information of the meta table displayed in M$TABLES.
Column Name | Description |
|---|---|
| NAME | Column name |
| TYPE | Column type |
| DATABASE_ID | Database identifier |
| ID | Column identifier |
| LENGTH | Column length |
| TABLE_ID | Column table identifier |
| FLAG | (Information for internal use of the server) |
| PART_PAGE_COUNT | Pages per partition |
| PAGE_VALUE_COUNT | Number of data per page |
| MINMAX_CACHE_SIZE | Size of MIN-MAX cache |
| MAX_CACHE_PART_COUNT | Maximum number of partition caches |