The Meta Tables are tables that present the schema information of Machbase. The table names begin with "M$".

These tables hold the table name, column information,  and index information, and reflect the creation, modification and deletion information resulting from the DDL statement.
The Meta Tables can not be added, deleted, or changed by the user.

User Objects


M$SYS_TABLES

Displays the table created by the user.

Column Name

Description

NAME

Table name

TYPE

Table type

DATABASE_ID

Database identifier

ID

Table identifier

USER ID

User of created table

COLCOUNT

Number of columns


Index



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

  • No labels