Meta Table
- Daniel Kim (Unlicensed)
- Kyle Song (Unlicensed)
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.
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 |